SQL Objects: syssqlstat
This object holds system information relating to SQL executions.
Column Datatype Description
SERVER_ID NUMBER Server ID
SQL_HASH VARCHAR Unique identifier for the SQL statement
SQL_TEXT VARCHAR First 500 characters of the SQL statement
EXECUTION_COUNT NUMBER Number of times the statement has been executed
CPU_TIME NUMBER The total amount of CPU time used (in milli or microseconds)
WAIT_TIME NUMBER The total amount of wait time (in milli or microseconds)
ELAPSED_TIME NUMBER Total elapsed time for the statement (in milli or microseconds)
PHYSICAL_READS NUMBER Total number of physical disk reads
PHYSICAL_WRITES NUMBER Total number of physical disk writes
LOGICAL_IO NUMBER Total number of memory I/O’s
PARSE_CALLS NUMBER Total number of times the statement has been parsed
SORTS_MEMORY NUMBER Total number of memory sorts
SORTS_DISK NUMBER Total number of disk sorts
TABLE_SCANS NUMBER Total number of full table scans performed
INDEX_LOOKUPS NUMBER Total number of index lookups performed
MEMORY_USED NUMBER Amount of memory used (in bytes)
ROWS_EXAMINED NUMBER Total number of rows accessed
ROWS_RETURNED NUMBER Total number of rows returned
FIRST_EXECUTED DATETIME First execution of the statement
LAST_EXECUTED DATETIME Last execution of the statement
CURRENT_EXECUTIONS NUMBER Total number of sessions currently running the statement
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:
- future
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Work Items
Dependency tree
* Blueprints in grey have been implemented.