GV$SGASTAT
select inst_id, -- INST_ID NUMBER '', -- POOL VARCHAR2(11) ksmssnam, -- NAME VARCHAR2(26) ksmsslen -- BYTES NUMBER from x$ksmfs where ksmsslen>1 union all select inst_id, -- INST_ID NUMBER 'shared pool', -- POOL VARCHAR2(11) ksmssnam, -- NAME VARCHAR2(26) ksmsslen -- BYTES NUMBER from x$ksmss where ksmsslen>1 union all select inst_id, -- INST_ID NUMBER 'large pool', -- POOL VARCHAR2(11) ksmssnam, -- NAME VARCHAR2(26) ksmsslen -- BYTES NUMBER from x$ksmls where ksmsslen>1 union all select inst_id, -- INST_ID NUMBER 'java pool', -- POOL VARCHAR2(11) ksmssnam, -- NAME VARCHAR2(26) ksmsslen -- BYTES NUMBER from x$ksmjs where ksmsslen>1

home |  up  |  mailbox