Re: How to find the exact SQL locking others?

On Monday, July 2, 2012, Alex Fatkulin <afatkulin@xxxxxxxxx> wrote:
> sql_id/prev_sql_id for session 1 will be useless. The first statement
> executed by session 1 might event be out of shared pool by now!
>
True, but you might still be able to see a trace of it in v$open_cursor.

Andy


--
http://www.freelists.org/webpage/oracle-l

Other related posts: