Re: How to find the exact SQL locking others?
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: "afatkulin@xxxxxxxxx" <afatkulin@xxxxxxxxx>
- Date: Mon, 2 Jul 2012 12:43:20 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
