V$SESSMETRIC displays the metric values for all sessions.
| Column | Datatype | Description |
|---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
SESSION_ID |
NUMBER |
Session ID |
SESSION_SERIAL_NUM |
NUMBER |
Session serial number |
CPU |
NUMBER |
CPU usage |
PHYSICAL_READS |
NUMBER |
Number of physical reads |
LOGICAL_READS |
NUMBER |
Number of logical reads |
PGA_MEMORY |
NUMBER |
PGA size at the end of the interval |
HARD_PARSES |
NUMBER |
Number of hard parses |
SOFT_PARSES |
NUMBER |
Number of soft parses |
PHYSICAL_READ_PCT |
NUMBER |
Physical read ratio |
LOGICAL_READ_PCT |
NUMBER |
Logical read ratio |