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>