Re: dbms_job issue

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 19 Feb 2004 17:39:33 -0800
Message-ID: <ozdZb.4490$C21.1854@fed1read07>

Forte Agent wrote:
>
> I am finding one of DBMS_JOB running very slow in one of our database.
> According to dba_jobs_running, there is only one job currently
> running, and v$session shows not many sessions at all. There is no
> enqueue lock in database. Buffer hit ratio and shared pool are all
> quiet. CPU and disk activities are not very high at all either. The
> session running this DBMS_JOB and all of job queue processes (shown as
> "(J00?)" in v$session) are running forever waiting on "jobq slave
> wait" event (according to v$session_wait). What should I do to
> diagnose this issue? Thank you in advance.

Enable SQL_TRACE & run the results thru TKPROF.

What does STATSPACK show? Received on Thu Feb 19 2004 - 19:39:33 CST