Oracle Apps concurrent program issue
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Thu, 2 Apr 2015 01:06:12 -0700
Message-ID: <CAHDOOG7DwBkHB4dav0iath-=hgT7aj9ATx6jPbg1SuPxSDbWVw_at_mail.gmail.com>
Hello:
A program that normally runs for 30 minutes was running for hours and this what I observed.
1. From v$session and v$active_session_history noticed that it was waiting on the same sql (waited short time).
2. v$session.row_wait_obj#, v$session.row_Wait_file#, v$session.row_wait_block# was pointing to the same object (which was an index). But the rowid that I got from this was also changing periodically (every 5 min)
3. The wait event was direct path temp read 4. The program definition was not changed recently Question is how to proceed further once we find the offending object and rows (index and rows which were changing). I was not able to tie this back to a session.
Date: Thu, 2 Apr 2015 01:06:12 -0700
Message-ID: <CAHDOOG7DwBkHB4dav0iath-=hgT7aj9ATx6jPbg1SuPxSDbWVw_at_mail.gmail.com>
Hello:
A program that normally runs for 30 minutes was running for hours and this what I observed.
1. From v$session and v$active_session_history noticed that it was waiting on the same sql (waited short time).
2. v$session.row_wait_obj#, v$session.row_Wait_file#, v$session.row_wait_block# was pointing to the same object (which was an index). But the rowid that I got from this was also changing periodically (every 5 min)
3. The wait event was direct path temp read 4. The program definition was not changed recently Question is how to proceed further once we find the offending object and rows (index and rows which were changing). I was not able to tie this back to a session.
Thank you
Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 02 2015 - 10:06:12 CEST