DBA Data[Home] [Help]

VIEW: SYS.V_$SESSMETRIC

Source

View Text - Preformatted

select "BEGIN_TIME","END_TIME","INTSIZE_CSEC","SESSION_ID","SESSION_SERIAL_NUM","CPU","PHYSICAL_READS","LOGICAL_READS","PGA_MEMORY","HARD_PARSES","SOFT_PARSES","PHYSICAL_READ_PCT","LOGICAL_READ_PCT","CON_ID" from v$sessmetric
View Text - HTML Formatted

SELECT "BEGIN_TIME"
, "END_TIME"
, "INTSIZE_CSEC"
, "SESSION_ID"
, "SESSION_SERIAL_NUM"
, "CPU"
, "PHYSICAL_READS"
, "LOGICAL_READS"
, "PGA_MEMORY"
, "HARD_PARSES"
, "SOFT_PARSES"
, "PHYSICAL_READ_PCT"
, "LOGICAL_READ_PCT"
, "CON_ID"
FROM V$SESSMETRIC