I/O Objects: sysfileio

Registered by Aarti Pai on 2008-10-31

sysfileio
This object holds system information relating to I/O operations and files (both data and log files)

Column Datatype Description
SERVER_ID NUMBER Server ID
FILE_NAME VARCHAR Name of the OS file
SCHEMA_NAME VARCHAR Name of the database schema
FILE_ENGINE VARCHAR The underlying engine that uses the file
PHYSICAL_READS NUMBER The total number of physical reads
PHYSICAL_WRITES NUMBER The total number of physical writes
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)

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
Brian Aker
Direction:
Needs approval
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.