var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm trying to create a query that will pull back data from v$session and also include the schema being accessed.
For example, we have several database users that have access to all the schemas. v$session shows me these users' sessions but doesn't show me which schema they're working with.
I can find this out in DBA studio by looking at the SQL for the session (in Edit Session), but I'm not sure how to get the information out from a query.
Any help appreciated!