Create Session Level Time Model Object: sesstime

Registered by Aarti Pai on 2008-11-01

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:
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.