V$SESSMETRIC
displays the metric values for all sessions.
Column | Datatype | Description |
---|---|---|
|
|
Begin time of the interval |
|
|
End time of the interval |
|
|
Interval size (in hundredths of a second) |
|
|
Session ID |
|
|
Session serial number |
|
|
CPU usage |
|
|
Number of physical reads |
|
|
Number of logical reads |
|
|
PGA size at the end of the interval |
|
|
Number of hard parses |
|
|
Number of soft parses |
|
|
Physical read ratio |
|
|
Logical read ratio |
|
|
The ID of the container to which the data pertains. Possible values include:
|