GV$OSSTAT

select
INST_ID,                 -- INST_ID NUMBER
KSUCPUSTATNAME,          -- STAT_NAME VARCHAR2(64)
decode                   -- VALUE NUMBER
  (KSUCPUSTATID, 15, KSUCPUSTATVALUE/1024, KSUCPUSTATVALUE),
KSUCPUSTATID             -- OSSTAT_ID NUMBER
from
X$KSUCPUSTAT 
union all 
select
INST_ID,                 -- INST_ID NUMBER
KSUVMSTATNAME,           -- STAT_NAME VARCHAR2(64)
KSUVMSTATVALUE,          -- VALUE NUMBER
KSUVMSTATID              -- OSSTAT_ID NUMBER
from
X$KSUVMSTAT
home |  up  |  mailbox