Join v$session and v$access : access « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. access

SQL>
SQL> SELECT a.sid, a.username, b.owner, b.object, b.type
  2  FROM   v$session a, v$access b
  3  WHERE  a.sid = b.sid
  4  and    rownum < 2;

       SID USERNAME
---------- ------------------------------
OWNER
----------------------------------------------------------------
OBJECT
--------------------------------------------------------------------------------
TYPE
------------------------
        44
SYS
COL$
TABLE


SQL>
SQL>