Session Info Tab
Displays the current status information of the session and the SQL information being executed in the session.
Wait event information
Displays information about wait events occurring in the current session.
Wait event
The number of wait events that have occurred in the current session
Wait time
The time spent waiting for the wait event that occurred in the current session
Basic information about the SQL executed by the session
SQL ID
SQL ID of the SQL being executed by the session
Previous Child Number
Child Number value of the SQL that was previously executed in the session
Child Number
Child Number value of the SQL being executed by the session
Previous SQL ID
SQL ID of the SQL previously executed by the session
SQL Full Text
Displays the full text of the SQL currently being executed in the session.
Plan Tree
This screen allows the users to view the plan for the SQL currently being executed in the current session. The SQL plan is displayed in a tree structure.
Session statistics
This is the status indicator for the current session.
The items for each status indicator are as follows.
∑
Cumulative values for each Statistics indicator in the session
Delta
The change value before and after refreshing the Statistics indicator for the session
Value/Sec
Delta value divided by the refresh time (in seconds)
The list of status indicators is as follows:
CONSISTENT_BLOCK_GETS_READONLY_PIN
Number of times consistent block gets were performed on read-only blocks
TOTAL_PARSE_COUNT
Total number of parses
REDO_ENTRIES
Number of redo entries (Redo entries: Redo records written by the session to the log buffer)
REDO_LOG_SIZE
Redo log size
REDO_WRITE_MULTI
Number of times when multiple sessions request to write the contents of the Redo log buffer
USER_ROLLBACKS
Number of times a user has requested a rollback
SERIAL_NUMBER
The serial number of the session
CONSISTENT_BLOCK_GETS_EXAMINE_NOWAIT
Number of times nowait was used for Consistent Read Mode examine
CURRENT_BLOCK_GETS
Number of times the data of the block in the current state has been read (current block gets: a number related to finding and pinning the latest version of the block in the buffer cache)
REQ_SERVICE_TIME
DB Time (total time spent by actual working threads)
CURRENT_BLOCK_GETS_EXAMINE
The number of times the Current examine feature is used to quickly obtain index branch peep or data block row lock information without pinning the block
BLOCK_DISK_READ
Time spent waiting for a block to be read from disk and loaded into the buffer cache
EXECUTE_COUNT
The number of times an SQL statement has been executed
CONSISTENT_BLOCK_GETS_EXAMINE
The number of times the Consistent Read (CR) examine function was used to quickly obtain the required values without pinning in index block unique key searches, etc.
REDO_WRITE
Time taken to write log blocks from the redo buffer to disk
LOGICAL_READS
The number of blocks read via memory I/O
HARD_PARSE_COUNT
Number of hard parses
PHYSICAL_READS
Number of blocks read via disk I/O
DB_CPU_TIME
CPU usage time
CONSISTENT_BLOCK_GETS
Number of blocks read in Consistent Read (CR) mode
PHYSICAL_WRITE
Number of blocks written to disk
Buffer Cache Hit
Buffer Cache hit rate
CONSISTENT_MULTI_BLOCK_GETS
Number of times CONSISTENT_BLOCK_GETS was performed on multiple blocks
Number of CURRENT_BLOCK_GETS_EXAMINE_NOWAIT
Number of times current block gets examine was performed without waiting
USER_COMMIT
Number of user commits in the session
CURRENT_BLOCK_GETS_NOWAIT
Number of times current block gets were performed without waiting (number of times current block gets were performed without waiting)
MULTI_BLOCK_DISK_READ
Number of times Multi Block was read from disk
Last updated