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. > > 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