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
