Hi All,

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!