Re: How to find the exact SQL locking others?
From: Andy Klock <andy_at_oracledepot.com>
Date: Mon, 2 Jul 2012 12:43:20 -0400
Message-ID: <CADo_RaNso_S9kBoh5U6kCLcfVTD_M19q4nQ4uPbg8MFV7OUPXw_at_mail.gmail.com>
On Monday, July 2, 2012, Alex Fatkulin <afatkulin_at_gmail.com> 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.
Date: Mon, 2 Jul 2012 12:43:20 -0400
Message-ID: <CADo_RaNso_S9kBoh5U6kCLcfVTD_M19q4nQ4uPbg8MFV7OUPXw_at_mail.gmail.com>
On Monday, July 2, 2012, Alex Fatkulin <afatkulin_at_gmail.com> 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-lReceived on Mon Jul 02 2012 - 11:43:20 CDT