Database Administration (MOSC)

MOSC Banner

detecting user sessions with invalid/lost state

edited May 6, 2011 9:01AM in Database Administration (MOSC) 6 commentsAnswered
 If I recompile a package that has global variables, I know that any existing user sessions that have accessed that package will lose the values they have set (their session state).

This will result in "ORA-04068: existing state of packages has been discarded" the next time they try to access that package.

All good so far.

What I want to do though, is pre-empt these messages and target only those user sessions that have lost that state, so I can get the sessions restarted and prevent them getting the error further down the line.

Is there a query or view that tells me which user sessions have stale/invalid state?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center