Sessions

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 (ms/s)

CPU Time spent for this session

See also:





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap