Database Administration (MOSC)

MOSC Banner

How can I know the sys_context of other sessions?

edited Mar 9, 2010 8:14PM in Database Administration (MOSC) 4 commentsAnswered
I am familiar with the use of application contexts, in particular the "USERENV" contexr provided out of the box as follows:
SELECT sys_context('<namespace>', '<parameter>', <length>);
FROM dual;

When I log on with DBA privs, I can easily see  my own session context. However, I would like to see the sys_context of other sessions - is there a view or table that I can use to do this?

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