question on DBMS_SCHEDULER.
- From: "Paresh Patel" <paresh.patel@xxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 May 2009 12:17:34 -0700
Folks,
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.
Appreciate your help...
Thanks,
Paresh Patel,
Other related posts:
