Re: question on DBMS_SCHEDULER.

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 13 May 2009 15:24:37 -0700
Message-ID: <bf46380905131524h3238a4c4w21ee5cf07ecf2fd0_at_mail.gmail.com>

On Wed, May 13, 2009 at 12:17 PM, Paresh Patel <paresh.patel_at_mantis-tgi.com>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

--
http://www.freelists.org/webpage/oracle-l

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