Hi,
is there a way to browse all e.g. sys_context(USER, <xy>) elements (or
sys_context('USERENV', <xy> elements) and displaying their values - w/
o knowing up-front, which <xy> are there?
- thanx!
cheers,
Frank

On Apr 6, 10:51*am, Frank Bergemann <FBergem... (AT) web (DOT) de> wrote:
Not that I am aware of though many of the data items can be found in v
$session. I believe most of the sys_context variables are stored in
the user PGA. Therefore there is no one control structure in the SGA
where a v$ or dba_ view could be built upon without Oracle having to
go back and reference every session PGA, which would be very
expensive, to get the information.

Now if you only want the information for a the current session rather
than for the entire instance I still do not think any such view exists
because I believe the data comes from different sturctures and the
sys_content function logic knows where to go to get the individual
data items.


HTH -- Mark D Powell --

Frank Bergemann (FBergemann (AT) web (DOT) de) wrote:
: Hi,
: is there a way to browse all e.g. sys_context(USER, <xy>) elements (or
: sys_context('USERENV', <xy> elements) and displaying their values - w/
: o knowing up-front, which <xy> are there?
: - thanx!
: cheers,
: Frank


select * from session_context;


(Depending on your database version of course.)