Re: question on DBMS_SCHEDULER.

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: paresh.patel@xxxxxxxxxxxxxx
  • Date: Wed, 13 May 2009 15:12:32 -0700

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On Wed, May 13, 2009 at 12:17 PM, Paresh Patel
<paresh.patel@xxxxxxxxxxxxxx>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.
>
> What does 'stuck' actually mean?

Error messages?

Re the SQL: setup a job to run following that one that dumps v$sqltext,
v$sql

>
>
> Appreciate your help…
>
>
>
> *Thanks,*
>
> *Paresh Patel,*
>

Other related posts: