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

Join v$session and v$access

   <source lang="sql">

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></source>