GV$SESSMETRIC

SELECT
inst_id,                 -- INST_ID NUMBER
begtime,                 -- BEGIN_TIME DATE
endtime,                 -- END_TIME DATE
intsize_csec,            -- INTSIZE_CSEC NUMBER
sessid,                  -- SESSION_ID NUMBER
sernum,                  -- SERIAL_NUM NUMBER
cpu,                     -- CPU NUMBER
phyrds,                  -- PHYSICAL_READS NUMBER
pga_memory,              -- PGA_MEMORY NUMBER
hard_parses,             -- HARD_PARSES NUMBER
soft_parses,             -- SOFT_PARSES NUMBER
phyrds_pct,              -- PHYSICAL_READ_PCT NUMBER
logrds_pct               -- LOGICAL_READ_PCT NUMBER
FROM
x$kewmsemv 
WHERE
flag1 = 1
home |  up  |  mailbox