Re: How to determine sessions with invalid package states
From: Rajeev Prabhakar <rprabha01_at_gmail.com>
Date: Thu, 7 May 2009 11:31:56 -0400
Message-ID: <2ba656800905070831j759dc228ta7456a49debae0a9_at_mail.gmail.com>
Hello Rumpi,
Date: Thu, 7 May 2009 11:31:56 -0400
Message-ID: <2ba656800905070831j759dc228ta7456a49debae0a9_at_mail.gmail.com>
Hello Rumpi,
May be you should look at v$access and/or v$open_cursor ? Between two of them, you could find your answer.
Rajeev
On Thu, May 7, 2009 at 10:35 AM, Rumpi Gravenstein <rgravens_at_gmail.com> wrote:
> I received a couple of responses on this -- the responses were around
> looking at locks. That will not help. I'm attempting to find packages that
> have invalid session state. The scenario is like so
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 07 2009 - 10:31:56 CDT