IO Objects: sysobjectio
This object holds system information relating to I/O operations and objects
Column Datatype Description
SERVER_ID NUMBER Server ID
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:
- future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.