Shared pool contents with their chuncks
                                                 Last update (2011-04-20 15:11:34)
                                                                                                                   Date added (2008-04-14 11:46:52)

Summary
All shared pool contents with their chuncks
SELECT KSMCHCOM  CONTENTS, COUNT(*)  CHUNKS, 
SUM(DECODE(KSMCHCLS, 'recr', KSMCHSIZ))  RECREATABLE, 
SUM(DECODE(KSMCHCLS, 'freeabl', KSMCHSIZ))  FREEABLE, 
SUM(KSMCHSIZ)  TOTAL
FROM SYS.X$KSMSP
WHERE INST_ID = USERENV('Instance') 
AND KSMCHCLS NOT LIKE 'R%'
GROUP BY KSMCHCOM;

CONTENTS             CHUNKS RECREATABLE   FREEABLE      TOTAL
---------------- ---------- ----------- ---------- ----------
KGFF heap                59        1344      37392      38736
KGK contexts              2                   2400       2400
KGK heap                  5        3504       1624       5128
KGL handles            5394     2023240               2023240
KQLS heap              1392      457080    1567408    2024488
LISTEN ADDRESS            2                   1144       1144
PL/SQL DIANA           1988      345680    3362024    3707704
PL/SQL MPCODE          1568      386440    2814848    3201288
PL/SQL PPCODE            41        9576      53424      63000
PLS cca hp desc           1                    208        208
PLS non-lib hp            1        2104                  2104
REGISTRAR TABLE           1                   2056       2056
SERVICE NAME EN           1                     40         40
SERVICE NAMES T           1                   1040       1040
XCT XGA                   1                     48         48
character set m           6                  31584      31584
character set o           4                   9672       9672
dictionary cach        1237                4687224    4687224
fixed allocatio          70        2800                  2800
free memory             675                         118324480
joxs heap                 1                     96         96
ksfqpa                    5                    360        360
ksfqpar                  10                   2880       2880
ksfqpn                    5                   4880       4880
kzull                   148                   7904       7904
library cache         16101     2369912    4369424    6739336
listener addres           1                     24         24
multiblock rea            2                   4144       4144
permanent memor           1                          55583872
row cache lru            76        3728                  3728
savepoints                1                     72         72
session param v          85                 346800     346800
sql area              13387     4958840   42571072   47529912
table columns            96       23704                 23704
table definiti           56        8448        264       8712
trigger defini           23       12320      10800      23120
trigger inform           12        1168                  1168
trigger source            2        1272                  1272

38 rows selected.

Elapsed: 00:00:00.06
Reviews
Filters
Search