SELECT * FROM v$subcache; OWNER_NAME NAME TYPE HEAP_NUM CACHE_ID CACHE_CNT HEAP_SZ HEAP_ALOC HEAP_USED ---------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- SYS X$KVIT 2 0 0 0 0 0 0 SYS V_$SQL 4 9 7 1 144 108 92 SYS V_$SQL 4 9 8 0 144 108 92 SYS V_$SQL 4 8 6 33 3908 3840 3760 SYS V_$SQL 4 8 36 0 3908 3840 3760 SYS X$KWDDEF 2 0 0 0 0 0 0 SYS GV$_LOCK 4 0 0 0 0 0 0 SYS GV$SQLAREA 4 0 0 0 0 0 0 SYS DUAL 2 9 1 1 144 108 92 SYS DUAL 2 9 2 0 144 108 92 SYS DUAL 2 8 0 1 256 220 204 SYS DUAL 2 8 3 0 256 220 204 SYS DUAL 2 8 35 0 256 220 204 SYS X$KSUSD 2 0 0 0 0 0 0 SYS X$KTCXB 2 0 0 0 0 0 0 SYS V_$FILESTAT 4 9 7 2 172 136 120 SYS V_$FILESTAT 4 9 8 0 172 136 120 SYS V_$FILESTAT 4 8 6 12 1460 1424 1408 SYS V_$FILESTAT 4 8 36 0 1460 1424 1408 SYS GV$FILESTAT 4 0 0 0 0 0 0 SYS GV$DATAFILE 4 0 0 0 0 0 0 SYS X$KGLLK 2 0 0 0 0 0 0 SYS X$KTADM 2 0 0 0 0 0 0 SYS GV$SESSION_WAIT 4 0 0 0 0 0 0 SYS X$KSMSD 2 0 0 0 0 0 0 SYS V$SUBCACHE 4 0 0 0 0 0 0 SYS V_$DATABASE 4 9 7 2 172 136 120 SYS V_$DATABASE 4 9 8 0 172 136 120 SYS V_$DATABASE 4 8 6 18 2212 2112 2080 SYS V_$DATABASE 4 8 36 0 2212 2112 2080 SYS GV$LOCKED_OBJECT 4 0 0 0 0 0 0 SYS OBJAUTH$ 2 8 0 8 2096 1868 1852 SYS OBJAUTH$ 2 8 3 2 2096 1868 1852 SYS OBJAUTH$ 2 8 35 0 2096 1868 1852 SYS GV$ROLLSTAT 4 0 0 0 0 0 0 SYS X$KQRST 2 0 0 0 0 0 0 SYS V$SQL 4 0 0 0 0 0 0 SYS GV$PROCESS 4 0 0 0 0 0 0 SYS V_$SESSION_OBJECT_CACHE 4 9 7 1 144 108 92 SYS V_$SESSION_OBJECT_CACHE 4 9 8 0 144 108 92 SYS V_$SESSION_OBJECT_CACHE 4 8 6 15 1796 1760 1744 SYS V_$SESSION_OBJECT_CACHE 4 8 36 0 1796 1760 1744 SYS V_$ROLLNAME 4 9 7 1 144 108 92 SYS V_$ROLLNAME 4 9 8 0 144 108 92 SYS V_$ROLLNAME 4 8 6 2 340 304 288 SYS V_$ROLLNAME 4 8 36 0 340 304 288 SYS SEG$ 2 10 4 16 35764 35408 35136 SYS SEG$ 2 10 5 0 35764 35408 35136 SYS SEG$ 2 8 0 20 2468 2364 2332 SYS SEG$ 2 8 3 0 2468 2364 2332 SYS SEG$ 2 8 35 0 2468 2364 2332 SYS IDL_UB1$ 2 8 0 6 1248 1212 1196 SYS IDL_UB1$ 2 8 3 1 1248 1212 1196 SYS IDL_UB1$ 2 8 35 0 1248 1212 1196 SYS GV$_LOCK1 4 0 0 0 0 0 0 SYS GV$MTS 4 0 0 0 0 0 0 SYS V_$BUFFER_POOL 4 9 7 1 144 108 92 SYS V_$BUFFER_POOL 4 9 8 0 144 108 92 SYS V_$BUFFER_POOL 4 8 6 8 1012 976 960 SYS V_$BUFFER_POOL 4 8 36 0 1012 976 960 SYS X$KSLED 2 0 0 0 0 0 0 SYS V_$INSTANCE 4 9 7 2 172 136 120 SYS V_$INSTANCE 4 9 8 0 172 136 120 SYS V_$INSTANCE 4 8 6 13 1572 1536 1520 SYS V_$INSTANCE 4 8 36 0 1572 1536 1520 SYS V_$SGASTAT 4 9 7 2 172 136 120 SYS V_$SGASTAT 4 9 8 0 172 136 120 SYS V_$SGASTAT 4 8 6 3 452 416 400 SYS V_$SGASTAT 4 8 36 0 452 416 400 SYS V_$SESS_IO 4 9 7 1 144 108 92 SYS V_$SESS_IO 4 9 8 0 144 108 92 SYS V_$SESS_IO 4 8 6 6 788 752 736 SYS V_$SESS_IO 4 8 36 0 788 752 736 SYS GV$BUFFER_POOL 4 0 0 0 0 0 0 SYS V$LOG 4 0 0 0 0 0 0 SYS IDL_SB4$ 2 8 0 6 1248 1212 1196 SYS IDL_SB4$ 2 8 3 1 1248 1212 1196 SYS IDL_SB4$ 2 8 35 0 1248 1212 1196 SYS X$KMMSG 2 0 0 0 0 0 0 SYS TRIGGER$ 2 8 0 18 3104 3004 2972 SYS TRIGGER$ 2 8 3 2 3104 3004 2972 SYS TRIGGER$ 2 8 35 0 3104 3004 2972 SYS GV$INSTANCE 4 0 0 0 0 0 0 SYS X$KGLNA 2 0 0 0 0 0 0 SYS PENDING_TRANS$ 2 8 0 23 3248 3180 3100 SYS PENDING_TRANS$ 2 8 3 1 3248 3180 3100 SYS PENDING_TRANS$ 2 8 35 0 3248 3180 3100 SYS V$MYSTAT 4 0 0 0 0 0 0 SYS V$ROLLSTAT 4 0 0 0 0 0 0 SYS V$SORT_USAGE 4 0 0 0 0 0 0 SYS FILE$ 2 8 0 14 2648 2572 2524 SYS FILE$ 2 8 3 2 2648 2572 2524 SYS FILE$ 2 8 35 0 2648 2572 2524 SYS X$KSMFS 2 0 0 0 0 0 0 SYS PROFILE$ 2 8 0 4 1024 988 972 SYS PROFILE$ 2 8 3 1 1024 988 972 SYS PROFILE$ 2 8 35 0 1024 988 972 SYS X$KSPPCV 2 0 0 0 0 0 0 SYS V$LOCK 4 0 0 0 0 0 0 SYS V$_LOCK1 4 0 0 0 0 0 0 SYS V$LOCKS_WITH_COLLISIONS 4 0 0 0 0 0 0 SYS V_$LIBRARYCACHE 4 9 7 2 172 136 120 SYS V_$LIBRARYCACHE 4 9 8 0 172 136 120 SYS V_$LIBRARYCACHE 4 8 6 14 1684 1648 1632 SYS V_$LIBRARYCACHE 4 8 36 0 1684 1648 1632 SYS OBJ$ 2 8 0 21 3984 3820 3740 SYS OBJ$ 2 8 3 3 3984 3820 3740 SYS OBJ$ 2 8 35 0 3984 3820 3740 SYS V_$OPEN_CURSOR 4 9 7 1 144 108 92 SYS V_$OPEN_CURSOR 4 9 8 0 144 108 92 SYS V_$OPEN_CURSOR 4 8 6 6 788 752 736 SYS V_$OPEN_CURSOR 4 8 36 0 788 752 736 SYS X$KGLST 2 0 0 0 0 0 0 SYS GV$STATNAME 4 0 0 0 0 0 0 SYS GV$SESS_IO 4 0 0 0 0 0 0 SYS ACCESS$ 2 8 0 4 1024 988 972 SYS ACCESS$ 2 8 3 1 1024 988 972 SYS ACCESS$ 2 8 35 0 1024 988 972 SYS X$KCCDI 2 0 0 0 0 0 0 SYS GV$OPEN_CURSOR 4 0 0 0 0 0 0 SYS IDL_UB2$ 2 8 0 6 1248 1212 1196 SYS IDL_UB2$ 2 8 3 1 1248 1212 1196 SYS IDL_UB2$ 2 8 35 0 1248 1212 1196 SYS X$KCCFN 2 0 0 0 0 0 0 SYS GV$LIBRARYCACHE 4 0 0 0 0 0 0 SYS V$DATABASE 4 0 0 0 0 0 0 SYS MIGRATE$ 2 8 0 3 648 460 428 SYS MIGRATE$ 2 8 3 0 648 460 428 SYS MIGRATE$ 2 8 35 0 648 460 428 SYS V$CONTROLFILE 4 0 0 0 0 0 0 SYS V$OPEN_CURSOR 4 0 0 0 0 0 0 SYS GV$SGASTAT 4 0 0 0 0 0 0 SYS X$KTSSO 2 0 0 0 0 0 0 SYS V_$MYSTAT 4 9 7 1 144 108 92 SYS V_$MYSTAT 4 9 8 0 144 108 92 SYS V_$MYSTAT 4 8 6 3 452 416 400 SYS V_$MYSTAT 4 8 36 0 452 416 400 SYS V$SQL_CURSOR 4 0 0 0 0 0 0 SYS V_$PARAMETER 4 9 7 2 172 136 120 SYS V_$PARAMETER 4 9 8 0 172 136 120 SYS V_$PARAMETER 4 8 6 10 1236 1200 1184 SYS V_$PARAMETER 4 8 36 0 1236 1200 1184 SYS GV$SQL_CURSOR 4 0 0 0 0 0 0 SYS V_$LOCK 4 9 7 2 172 136 120 SYS V_$LOCK 4 9 8 0 172 136 120 SYS V_$LOCK 4 8 6 10 1236 1200 1184 SYS V_$LOCK 4 8 36 0 1236 1200 1184 SYS FET$ 2 10 4 4 9028 8912 8832 SYS FET$ 2 10 5 0 9028 8912 8832 SYS FET$ 2 8 0 4 592 556 540 SYS FET$ 2 8 3 0 592 556 540 SYS FET$ 2 8 35 0 592 556 540 SYS UET$ 2 10 4 7 15912 15536 15408 SYS UET$ 2 10 5 0 15912 15536 15408 SYS UET$ 2 8 0 7 928 892 876 SYS UET$ 2 8 3 0 928 892 876 SYS UET$ 2 8 35 0 928 892 876 SYS DBMS_STANDARD 9 0 0 0 0 0 0 SYS V$FILESTAT 4 0 0 0 0 0 0 SYS V_$LOCK_ACTIVITY 4 9 7 1 144 108 92 SYS V_$LOCK_ACTIVITY 4 9 8 0 144 108 92 SYS V_$LOCK_ACTIVITY 4 8 6 4 564 528 512 SYS V_$LOCK_ACTIVITY 4 8 36 0 564 528 512 SYS TS$ 2 8 0 32 4280 4156 4108 SYS TS$ 2 8 3 1 4280 4156 4108 SYS TS$ 2 8 35 0 4280 4156 4108 SYS PROPS$ 2 8 0 3 480 444 428 SYS PROPS$ 2 8 3 0 480 444 428 SYS PROPS$ 2 8 35 0 480 444 428 SYS GV$SORT_USAGE 4 0 0 0 0 0 0 SYS X$KSUPR 2 0 0 0 0 0 0 SYS KOPM$ 2 8 0 3 912 876 860 SYS KOPM$ 2 8 3 1 912 876 860 SYS KOPM$ 2 8 35 0 912 876 860 SYS USER$ 2 8 0 25 3496 3372 3324 SYS USER$ 2 8 3 1 3496 3372 3324 SYS USER$ 2 8 35 0 3496 3372 3324 SYS PROXY$ 2 8 0 4 1244 1004 972 SYS PROXY$ 2 8 3 1 1244 1004 972 SYS PROXY$ 2 8 35 0 1244 1004 972 SYS V$BH 4 0 0 0 0 0 0 SYS GV$BH 4 0 0 0 0 0 0 SYS X$BH 2 0 0 0 0 0 0 SYS V_$RESERVED_WORDS 4 9 7 1 144 108 92 SYS V_$RESERVED_WORDS 4 9 8 0 144 108 92 SYS V_$RESERVED_WORDS 4 8 6 2 340 304 288 SYS V_$RESERVED_WORDS 4 8 36 0 340 304 288 SYS V_$SQL_SHARED_MEMORY 4 9 7 1 144 108 92 SYS V_$SQL_SHARED_MEMORY 4 9 8 0 144 108 92 SYS V_$SQL_SHARED_MEMORY 4 8 6 11 1348 1312 1296 SYS V_$SQL_SHARED_MEMORY 4 8 36 0 1348 1312 1296 SYS V_$LOG 4 9 7 1 144 108 92 SYS V_$LOG 4 9 8 0 144 108 92 SYS V_$LOG 4 8 6 9 1124 1088 1072 SYS V_$LOG 4 8 36 0 1124 1088 1072 SYS V$_LOCK 4 0 0 0 0 0 0 SYS GV$RESERVED_WORDS 4 0 0 0 0 0 0 SYS X$KDNSSF 2 0 0 0 0 0 0 SYS X$KSUMYSTA 2 0 0 0 0 0 0 SYS X$KSMSS 2 0 0 0 0 0 0 SYS V$LOCK_ACTIVITY 4 0 0 0 0 0 0 SYS X$KSQRS 2 0 0 0 0 0 0 SYS GV$SQL_SHARED_MEMORY 4 0 0 0 0 0 0 SYS C_COBJ# 3 8 10 1 696 640 608 SYS C_COBJ# 3 8 11 1 696 640 608 SYS V_$SQL_CURSOR 4 9 7 1 144 108 92 SYS V_$SQL_CURSOR 4 9 8 0 144 108 92 SYS V_$SQL_CURSOR 4 8 6 14 1684 1648 1632 SYS V_$SQL_CURSOR 4 8 36 0 1684 1648 1632 SYS CLU$ 2 8 0 26 3140 3036 3004 SYS CLU$ 2 8 3 0 3140 3036 3004 SYS CLU$ 2 8 35 0 3140 3036 3004 SYS GV$CONTROLFILE 4 0 0 0 0 0 0 SYS V_$ROWCACHE 4 9 7 2 172 136 120 SYS V_$ROWCACHE 4 9 8 0 172 136 120 SYS V_$ROWCACHE 4 8 6 17 2096 1984 1968 SYS V_$ROWCACHE 4 8 36 0 2096 1984 1968 SYS V_$SGA 4 9 7 2 172 136 120 SYS V_$SGA 4 9 8 0 172 136 120 SYS V_$SGA 4 8 6 2 340 304 288 SYS V_$SGA 4 8 36 0 340 304 288 SYS DEPENDENCY$ 2 8 0 7 1792 1756 1740 SYS DEPENDENCY$ 2 8 3 2 1792 1756 1740 SYS DEPENDENCY$ 2 8 35 0 1792 1756 1740 SYS GV$DATABASE 4 0 0 0 0 0 0 SYS V$SESSION_OBJECT_CACHE 4 0 0 0 0 0 0 SYS STANDARD 9 0 0 0 0 0 0 SYS V$SQLAREA 4 0 0 0 0 0 0 SYS X$LE_STAT 2 0 0 0 0 0 0 SYS V$RESERVED_WORDS 4 0 0 0 0 0 0 SYS V_$CONTROLFILE 4 9 7 1 144 108 92 SYS V_$CONTROLFILE 4 9 8 0 144 108 92 SYS V_$CONTROLFILE 4 8 6 2 340 304 288 SYS V_$CONTROLFILE 4 8 36 0 340 304 288 SYS X$KSUSESTA 2 0 0 0 0 0 0 SYS V$INSTANCE 4 0 0 0 0 0 0 SYS IDL_CHAR$ 2 8 0 6 1248 1212 1196 SYS IDL_CHAR$ 2 8 3 1 1248 1212 1196 SYS IDL_CHAR$ 2 8 35 0 1248 1212 1196 SYS LOC$ 2 8 0 3 480 444 428 SYS LOC$ 2 8 3 0 480 444 428 SYS LOC$ 2 8 35 0 480 444 428 SYS X$KCCRT 2 0 0 0 0 0 0 SYS V$SESSTAT 4 0 0 0 0 0 0 SYS V_$SORT_USAGE 4 9 7 1 144 108 92 SYS V_$SORT_USAGE 4 9 8 0 144 108 92 SYS V_$SORT_USAGE 4 8 6 12 1460 1424 1408 SYS V_$SORT_USAGE 4 8 36 0 1460 1424 1408 SYS V_$ROLLSTAT 4 9 7 1 144 108 92 SYS V_$ROLLSTAT 4 9 8 0 144 108 92 SYS V_$ROLLSTAT 4 8 6 17 2096 1984 1968 SYS V_$ROLLSTAT 4 8 36 0 2096 1984 1968 SYS X$KSPPI 2 0 0 0 0 0 0 SYS V$PARAMETER 4 0 0 0 0 0 0 SYS V$SGASTAT 4 0 0 0 0 0 0 SYS COL$ 2 8 0 24 4320 4156 4076 SYS COL$ 2 8 3 3 4320 4156 4076 SYS COL$ 2 8 35 0 4320 4156 4076 SYS X$LE 2 0 0 0 0 0 0 SYS V_$SESSION 4 9 7 2 172 136 120 SYS V_$SESSION 4 9 8 0 172 136 120 SYS V_$SESSION 4 8 6 44 5236 5088 4992 SYS V_$SESSION 4 8 36 0 5236 5088 4992 SYS GV$LOCK 4 0 0 0 0 0 0 SYS GV$MYSTAT 4 0 0 0 0 0 0 SYS V$LIBRARYCACHE 4 0 0 0 0 0 0 SYS V_$MTS 4 9 7 1 144 108 92 SYS V_$MTS 4 9 8 0 144 108 92 SYS V_$MTS 4 8 6 4 564 528 512 SYS V_$MTS 4 8 36 0 564 528 512 SYS X$KSUXSINST 2 0 0 0 0 0 0 SYS X$KSUSIO 2 0 0 0 0 0 0 SYS CDEF$ 2 8 0 21 4664 4268 4172 SYS CDEF$ 2 8 3 4 4664 4268 4172 SYS CDEF$ 2 8 35 0 4664 4268 4172 SYS V$DATAFILE 4 0 0 0 0 0 0 SYS BOOTSTRAP$ 2 8 0 3 480 444 428 SYS BOOTSTRAP$ 2 8 3 0 480 444 428 SYS BOOTSTRAP$ 2 8 35 0 480 444 428 SYS C_FILE#_BLOCK# 3 8 10 3 1116 880 832 SYS C_FILE#_BLOCK# 3 8 11 1 1116 880 832 SYS V$BUFFER_POOL 4 0 0 0 0 0 0 SYS X$KSUSE 2 0 0 0 0 0 0 SYS GV$SGA 4 0 0 0 0 0 0 SYS C_OBJ# 3 8 10 1 704 640 608 SYS C_OBJ# 3 8 11 1 704 640 608 SYS ID_GENS$ 2 8 0 1 256 220 204 SYS ID_GENS$ 2 8 3 0 256 220 204 SYS ID_GENS$ 2 8 35 0 256 220 204 SYS X$KCVFH 2 0 0 0 0 0 0 SYS GV$LOCK_ACTIVITY 4 0 0 0 0 0 0 SYS GV$SQLTEXT 4 0 0 0 0 0 0 SYS GV$SESSTAT 4 0 0 0 0 0 0 SYS ICOL$ 2 8 0 14 2392 2124 2092 SYS ICOL$ 2 8 3 1 2392 2124 2092 SYS ICOL$ 2 8 35 0 2392 2124 2092 SYS V$PROCESS 4 0 0 0 0 0 0 SYS SYSAUTH$ 2 8 0 4 1024 988 972 SYS SYSAUTH$ 2 8 3 1 1024 988 972 SYS SYSAUTH$ 2 8 35 0 1024 988 972 SYS DBMS_OUTPUT 9 9 15 1 116 80 64 SYS V_$SQLTEXT 4 9 7 1 144 108 92 SYS V_$SQLTEXT 4 9 8 0 144 108 92 SYS V_$SQLTEXT 4 8 6 5 676 640 624 SYS V_$SQLTEXT 4 8 36 0 676 640 624 SYS V_$LOCKED_OBJECT 4 9 7 1 144 108 92 SYS V_$LOCKED_OBJECT 4 9 8 0 144 108 92 SYS V_$LOCKED_OBJECT 4 8 6 9 1124 1088 1072 SYS V_$LOCKED_OBJECT 4 8 36 0 1124 1088 1072 SYS V$SQLTEXT 4 0 0 0 0 0 0 SYS CON$ 2 8 0 9 2088 2012 1964 SYS CON$ 2 8 3 2 2088 2012 1964 SYS CON$ 2 8 35 0 2088 2012 1964 SYS X$KCCLE 2 0 0 0 0 0 0 SYS X$KSUSECST 2 0 0 0 0 0 0 SYS X$KCFIO 2 0 0 0 0 0 0 SYS X$KSMHP 2 0 0 0 0 0 0 SYS V_$STATNAME 4 9 7 1 144 108 92 SYS V_$STATNAME 4 9 8 0 144 108 92 SYS V_$STATNAME 4 8 6 3 452 416 400 SYS V_$STATNAME 4 8 36 0 452 416 400 SYS V$LOCKED_OBJECT 4 0 0 0 0 0 0 SYS TAB$ 2 8 0 37 4920 4732 4668 SYS TAB$ 2 8 3 1 4920 4732 4668 SYS TAB$ 2 8 35 0 4920 4732 4668 SYS SEQ$ 2 10 4 7 15712 15536 15408 SYS SEQ$ 2 10 5 0 15712 15536 15408 SYS SEQ$ 2 8 0 9 1584 1548 1532 SYS SEQ$ 2 8 3 1 1584 1548 1532 SYS SEQ$ 2 8 35 0 1584 1548 1532 SYS GV$LOG 4 0 0 0 0 0 0 SYS V_$LOCKS_WITH_COLLISIONS 4 9 7 1 144 108 92 SYS V_$LOCKS_WITH_COLLISIONS 4 9 8 0 144 108 92 SYS V_$LOCKS_WITH_COLLISIONS 4 8 6 1 228 192 176 SYS V_$LOCKS_WITH_COLLISIONS 4 8 36 0 228 192 176 SYS IND$ 2 8 0 34 4660 4380 4332 SYS IND$ 2 8 3 1 4660 4380 4332 SYS IND$ 2 8 35 0 4660 4380 4332 SYS V$SGA 4 0 0 0 0 0 0 SYS X$KCBWBPD 2 0 0 0 0 0 0 SYS V_$PROCESS 4 9 7 2 172 136 120 SYS V_$PROCESS 4 9 8 0 172 136 120 SYS V_$PROCESS 4 8 6 10 1236 1200 1184 SYS V_$PROCESS 4 8 36 0 1236 1200 1184 SYS C_USER# 3 8 10 1 704 640 608 SYS C_USER# 3 8 11 1 704 640 608 SYS V_$DATAFILE 4 9 7 2 172 136 120 SYS V_$DATAFILE 4 9 8 0 172 136 120 SYS V_$DATAFILE 4 8 6 22 2676 2608 2528 SYS V_$DATAFILE 4 8 36 0 2676 2608 2528 SYS INDPART$ 2 8 0 27 3696 3628 3548 SYS INDPART$ 2 8 3 1 3696 3628 3548 SYS INDPART$ 2 8 35 0 3696 3628 3548 SYS V_$SQLAREA 4 9 7 1 144 108 92 SYS V_$SQLAREA 4 9 8 0 144 108 92 SYS V_$SQLAREA 4 8 6 30 3572 3504 3424 SYS V_$SQLAREA 4 8 36 0 3572 3504 3424 SYS UNDO$ 2 10 4 6 13484 13328 13216 SYS UNDO$ 2 10 5 0 13484 13328 13216 SYS UNDO$ 2 8 0 22 3628 3484 3420 SYS UNDO$ 2 8 3 2 3628 3484 3420 SYS UNDO$ 2 8 35 0 3628 3484 3420 SYS V$ROWCACHE 4 0 0 0 0 0 0 SYS GV$SUBCACHE 4 0 0 0 0 0 0 SYS GV$SESSION 4 0 0 0 0 0 0 SYS X$KQLSET 2 0 0 0 0 0 0 SYS X$KOCST 2 0 0 0 0 0 0 SYS V$SESSION_WAIT 4 0 0 0 0 0 0 SYS V_$SESSTAT 4 9 7 1 144 108 92 SYS V_$SESSTAT 4 9 8 0 144 108 92 SYS V_$SESSTAT 4 8 6 3 452 416 400 SYS V_$SESSTAT 4 8 36 0 452 416 400 SYS X$KSQEQ 2 0 0 0 0 0 0 SYS V_$SUBCACHE 4 9 7 1 144 108 92 SYS V_$SUBCACHE 4 9 8 0 144 108 92 SYS V_$SUBCACHE 4 8 6 9 1124 1088 1072 SYS V_$SUBCACHE 4 8 36 0 1124 1088 1072 SYS CCOL$ 2 8 0 11 2312 2236 2188 SYS CCOL$ 2 8 3 2 2312 2236 2188 SYS CCOL$ 2 8 35 0 2312 2236 2188 SYS V_$SESSION_WAIT 4 9 7 1 144 108 92 SYS V_$SESSION_WAIT 4 9 8 0 144 108 92 SYS V_$SESSION_WAIT 4 8 6 15 1796 1760 1744 SYS V_$SESSION_WAIT 4 8 36 0 1796 1760 1744 SYS X$KSMLS 2 0 0 0 0 0 0 SYS GV$PARAMETER 4 0 0 0 0 0 0 SYS V$SQL_SHARED_MEMORY 4 0 0 0 0 0 0 SYS X$KCCCF 2 0 0 0 0 0 0 SYS X$KGLCURSOR 2 0 0 0 0 0 0 SYS X$KCCFE 2 0 0 0 0 0 0 SYS X$KXSCC 2 0 0 0 0 0 0 SYS VIEW$ 2 8 0 8 1472 1436 1420 SYS VIEW$ 2 8 3 1 1472 1436 1420 SYS VIEW$ 2 8 35 0 1472 1436 1420 SYS V$SESS_IO 4 0 0 0 0 0 0 SYS PROCEDURE$ 2 8 0 4 1024 988 972 SYS PROCEDURE$ 2 8 3 1 1024 988 972 SYS PROCEDURE$ 2 8 35 0 1024 988 972 SYS V$SESSION 4 0 0 0 0 0 0 SYS GV$SQL 4 0 0 0 0 0 0 SYS SYN$ 2 8 0 4 1024 988 972 SYS SYN$ 2 8 3 1 1024 988 972 SYS SYN$ 2 8 35 0 1024 988 972 SYS GV$ROWCACHE 4 0 0 0 0 0 0 SYS X$KTURD 2 0 0 0 0 0 0 SYS V$MTS 4 0 0 0 0 0 0 SYS GV$SESSION_OBJECT_CACHE 4 0 0 0 0 0 0 SYS C_TS# 3 8 10 1 704 640 608 SYS C_TS# 3 8 11 1 704 640 608 SYS V$STATNAME 4 0 0 0 0 0 0