Re: dbms_job issue

From: Raj <m_raj_mohan_at_yahoo.com>
Date: 20 Feb 2004 01:33:50 -0800
Message-ID: <3e5dad90.0402200133.6408a662@posting.google.com>

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<ozdZb.4490$C21.1854_at_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?

Do you have any dbms_job.broken call ? If yes, issue a commit after the call.

Thanks. Received on Fri Feb 20 2004 - 03:33:50 CST