select * from V$ACCESS

SID | OWNER | OBJECT | TYPE
7 | SYS | CDEF$ | TABLE
7 | SYS | COL$ | TABLE
7 | SYS | ICOL$ | TABLE
7 | SYS | IND$ | TABLE
7 | SYS | JOB$ | TABLE
7 | SYS | OBJ$ | TABLE
7 | SYS | TAB$ | TABLE
7 | SYS | USER$ | TABLE
9 | PUBLIC | V$ACCESS | SYNONYM
9 | SYS | GV$ACCESS | VIEW
9 | SYS | V$ACCESS | VIEW
9 | SYS | V_$ACCESS | VIEW
9 | SYS | X$KGLDP | TABLE
9 | SYS | X$KGLLK | TABLE
9 | SYS | X$KGLOB | TABLE
9 | SYS | X$KSUSE | TABLE
9 | SYSTEM | V$ACCESS | CURSOR
11 | PUBLIC | V$SGASTAT | SYNONYM
11 | SYS | GV$SGASTAT | VIEW
11 | SYS | V$SGASTAT | VIEW
11 | SYS | V_$SGASTAT | VIEW
11 | SYS | X$KSMFS | TABLE
11 | SYS | X$KSMJS | TABLE
11 | SYS | X$KSMLS | TABLE
11 | SYS | X$KSMSS | TABLE
11 | SYSTEM | V$SGASTAT | CURSOR