SQL Language (MOSC)

MOSC Banner

list all session context values

edited Oct 21, 2010 4:59AM in SQL Language (MOSC) 2 commentsAnswered
Hello,
We have an application using specific context. We would be able to monitor some values when application is running.
Is there a way to list all context values that are in-memory (with a system user) ?

For exemple, after our application logon screen, we initialize an oracle context named 'CRW_SESSION'. This context has a variable named VERSION which is initialized with the client application version used.
On a specific time, we would like to query all the context in memory to see if there is a client connected with the version X.
Is that possible ?

Thank you for your help ?

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