Re: How to determine sessions with invalid package states
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Thu, 7 May 2009 10:35:34 -0400
Message-ID: <9c9b9dc90905070735o2f77efd9y5295ac98bf7ce51_at_mail.gmail.com>
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
Date: Thu, 7 May 2009 10:35:34 -0400
Message-ID: <9c9b9dc90905070735o2f77efd9y5295ac98bf7ce51_at_mail.gmail.com>
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
Session one calls package TEST that creates session state A
Session two recompiles package TEST. If session one had a lock, this would not be possible. At this point session one's package state is invalid.
Session one calls package TEST and receives something along the lines of: ORA-*04068: existing state of packagesstringstringstring has been discarded *
On Wed, May 6, 2009 at 1:27 PM, Rumpi Gravenstein <rgravens_at_gmail.com>wrote:
> All,
>
> Is it possible to write a query to identify sessions that are holding
> invalidated package states? We are looking at issues around code
> migrations. The goal is to only recycle sessions that we know will have
> problems. Any ideas?
>
> --
> Rumpi Gravenstein
>
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 07 2009 - 09:35:34 CDT