GV$SGASTAT definition in Oracle 8i / www.oracledba.ru
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