Jobs are in waiting status

puppy

Active Member
Hi All,

Today suddenly all Jobs are going in 'W' waiting status and takes long time to complete.

Usually all jobs will go to 'P' Processing then will be complete.

Please let me know how to find the root cause for this.

Thanks & Regards,
Puppy.
 
There is a lot to investigate . But at a basic level , you should start searching for any locks , the processing jobs have created in the database . Check for cpu utilisation , user I/O sessions . Network also plays an imp role. there might be slowness issues due to taht too . Queue capability whether its a single thraeded/ multi threaded . check for the e1rootlogs etc .
 
Back
Top