Create Session Level SQL Execution Object: sesssql

Registered by Aarti Pai

sesssql
If implementation is possible, it could do away with the sysquerylog object:
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
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
FIRST_ISSUED DATETIME Date/time when query was first issued
LAST_ISSUED DATETIME Date/time when query was last issued
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_ACCESSED NUMBER Total number of rows accessed
FIRST_EXECUTED DATETIME First execution of the statement
LAST_EXECUTED DATETIME Last execution of the statement
CURRENTLY_RUNNING CHAR If statement is currently being executed

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.