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