Oracle PL/SQL Tutorial/System Tables Data Dictionary/access

Join v$session and v$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>