Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$SESSMETRIC

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