Re: How to determine sessions with invalid package states

  • From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
  • To: rgravens@xxxxxxxxx
  • Date: Thu, 7 May 2009 11:31:56 -0400

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: