Create Session Level Time Model Object: sesstime
Registered by
Aarti Pai
sesstime
This object holds system information relating to amount of time a session has spent various activities.
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 ACTIVITY_NAME
VARCHAR Activity the session has engaged in ACTIVITY_TIME
NUMBER Total amount of time spent in activity (in milli or possibly microseconds)
Notes:
Possible tracked activities could include:
Database CPU time
SQL execution time
SQL parse time
Procedure execution time
Trigger execution time
Temp table creation time
InnoDB log flush time
Idle time
Others?
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.