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')