The Sessions window shows information about the Sessions activity.
The grid located at the top of the window shows each individual session with the following information for each one:
Sid Session identifier Serial Number Serial Number (The combination of Sid and Serial Number is unique) Type Session type (USER, BACKGROUND) UserName Oracle user name Status Status of the session: ACTIVE, INACTIVE, KILLED Server Server type: DEDICATED, SHARED, PSEUDO, NONE Machine Operating system machine name Program Operating system program name Logon time Logon time Block Changes Block Changes for this session Consistent changes Consistent changes for this session Block Gets Block Gets for this session Consistent Gets Consistent Gets for this session Physical Reads Physical Reads for this session Physical Writes Physical Writes for this session Cpu (ms) Amount of CPU time spent for this session Commits Number of commits for this session Rollbacks Number of Rollbacks for this session Calls Number of calls for this session Parse Total Number of Parse for this session Parse Hard Number of Hard Parse for this session Executes Number of execute for this session SQL First 60 characters of the SQL statement that is parsed into the open cursor Process Operating system client process ID Os USer Operating system client user name Module Contains the name of the currently executing module Action Contains the name of the currently executing action Client Info Information set by the DBMS_APPLICATION_INFO.SET_ CLIENT_INFO procedure
By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.
Select one or more sessions in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several sessions are selected, the statistics are aggregated.
I/O (per second)
Block Changes Block Changes Block Gets Block Gets Consistent Gets Consistent Gets Logical IO Logical IO Physical Reads Physical Reads Physical Writes Physical Writes
Calls (per second)
Calls Number of calls per second Parse (total) Number of parse per second Parse (hard) Number of hard parse per second.
If a session executes an SQL statement that does not exist in the shared pool, then Oracle has to do a hard parse:
- Allocates memory for the statement from the shared pool.
- Check the statement syntactically
- Check if the user trying to execute the statement has the necessary rights to execute it
Exec/Open Number of Cursor open/execute per second Commit Number of commit per second Rollback Number of rollback per second
CPU Time spent for this session
Copyright © AgileLoad. All rights reserved.