Create Session Level I/O Object: sessobjectio

Registered by Aarti Pai on 2008-11-01

sessobjectio
This object holds session information relating to I/O operations and objects

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
OBJECT_SCHEMA VARCHAR Name of the database schema
OBJECT_NAME VARCHAR Name of object
OBJECT_TYPE VARCHAR Type of object (table, index)
OBJECT_ENGINE VARCHAR The underlying engine of the object
PHYSICAL_READS NUMBER The total number of physical reads
PHYSICAL_WRITES NUMBER The total number of physical writes
LOGICAL_READS NUMBER The total number of memory reads
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 physical read time (in milliseconds)
WRITE_TIME NUMBER The total amount of physical write time (in milliseconds)
ROWS_INSERTED NUMBER The total number of rows inserted
ROWS_UPDATED NUMBER The total number of rows updated
ROWS_DELETED NUMBER The total number of rows deleted

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
Brian Aker
Direction:
Approved
Assignee:
None
Definition:
Approved
Series goal:
Accepted for trunk
Implementation:
Not started
Milestone target:
milestone icon future

Related branches

Sprints

Whiteboard

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.