Re: question on DBMS_SCHEDULER.

From: Jared Still <>
Date: Wed, 13 May 2009 15:24:37 -0700
Message-ID: <>

On Wed, May 13, 2009 at 12:17 PM, Paresh Patel <>wrote:

> I have one procedure which contains no of DML statements. We have used
> DBMS_SCHEDULER to kick off this procedure every night. This procedure gets
> stuck intermittently and we tried to find out the exact SQL statement which
> is getting stuck using data dictionary views but we couldn’t as Oracle
> server doesn’t provide SQL_ID/SQL_HASH_VALUE/SQL_ADDRESS or in v$SESSION.
> If anyone has any idea please do let me know.
> Hmm, hit the space bar and gmail thought it was <SEND> ...

I will try again.

What does 'stuck' actually mean?

Error messages?

Is this a procedure you can modify?

If so, then instrument it to do logging, and you can easily see where it dies.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed May 13 2009 - 17:24:37 CDT

Original text of this message