SELECT
begin_time, -- BEGIN_TIME DATE
end_time, -- END_TIME DATE
intsize_csec, -- INTSIZE_CSEC NUMBER
session_id, -- SESSION_ID NUMBER
serial_num, -- SESSION_SERIAL_NUM NUMBER
cpu, -- CPU NUMBER
physical_reads, -- PHYSICAL_READS NUMBER
logical_reads, -- LOGICAL_READS NUMBER
pga_memory, -- PGA_MEMORY NUMBER
hard_parses, -- HARD_PARSES NUMBER
soft_parses, -- SOFT_PARSES NUMBER
physical_read_pct, -- PHYSICAL_READ_PCT NUMBER
logical_read_pct -- LOGICAL_READ_PCT NUMBER
FROM
gv$sessmetric
WHERE
inst_id = USERENV('INSTANCE')