Create Session Level I/O Object:

sessio
This object holds session information relating to I/O operations.

Column Datatype Description
SERVER_ID NUMBER Server ID
SESSION_ID NUMBER Connection ID
USER_NAME VARCHAR Name of the user
USER_HOST VARCHAR Name of the user host
PHYSICAL_READS NUMBER The total number of physical reads
PHYSICAL_WRITES NUMBER The total number of physical writes
LOGICAL_IO NUMBER The total number of logical I/O
COMMITS NUMBER Total commits caused by the connection
ROLLBACKS NUMBER Total rollbacks caused by the connection
TABLE_SCANS NUMBER Total number of full table scans performed
INDEX_LOOKUPS NUMBER Total number of index lookups performed
READ_TIME NUMBER The total amount of read time (in milliseconds)
WRITE_TIME NUMBER The total amount of write time (in milliseconds)
READ_WAIT_TIME NUMBER The total amount of wait time for reads (in milliseconds)
WRITE_WAIT_TIME NUMBER The total amount of wait time for writes (in milliseconds)