Performance Trend
The Performance Trend provides a macro-level view of changes in each indicator through the Overall chart and allows the users to check session and SQL indicators down to the second at the time of the problem using time slices. This enables the users to identify the time of the problem and its cause in one go. When the users first enter the Performance Trend menu, the users can view the Overall chart. The users can check the trends for each instance by time interval, including CPU, Memory, Session, and Wait Class.
Overall Chart
The Overall chart in Performance Trend shows the trend and summary information of CPU, Memory, Running Session, and Wait Class values during the query period. It provides detailed analysis by time and date, and the users can select the chart interval and aggregation method from the drop-down menu for each graph. Additionally, the users can view the value of the indicator by hovering the mouse over it.
Clicking on a chart will take the users to the Time Slice page for the 1-hour range at that point in time, enabling more detailed analysis.
CPU (Sys + User + IO)
Displays the trend of CPU usage changes during the specified time interval.
Memory
Displays the trend of memory usage during the selected analysis period.
Running Session
The users can check the trend of the Running Session Count during the selected analysis period.
Wait Class
The users can view the trend of Wait Class Time that occurred during the selected analysis period.
Performance Chart
The Performance Chart is a screen that displays the Performance Trend for a specified time period, enabling detailed analysis of CPU, Memory, Session, and Wait Class metrics.
The upper and middle charts show session indicators by category, DB performance statistics, memory usage, percentage distribution by Wait Class, Time/Count indicators for major Wait Events, and hourly changes in the time consumed by each Wait Class.
Clicking the top chart displays a second-level chart in the middle. Clicking the second-level chart and selecting a category allows the users to view session-related metrics, SQL execution-related metrics, lock-related metrics, and wait event-related metrics at that specific point in time.
The following is a description of the charts provided at the top of the Performance Chart screen.
Session
Provides information about running sessions by time interval in a bar chart. The users can select the desired metric by choosing the legend in the top-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
Stat
Provides information for each metric (Logical Reads, Physical Reads, Redo Entries, etc.) by time interval in a bar chart. The users can select the desired metric by choosing the legend in the upper-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
CPU
Provides CPU usage rate information by time interval. The users can select the desired CPU usage rate metric by choosing the legend in the top-right corner. Additionally, the users can select the MIN, MAX, or AVG aggregation method using the combo box.
Memory
Provides memory usage information by time interval. The users can select the desired metrics by choosing the legend in the upper-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
Wait (%)
Displays the same data in a more intuitive format as a percentage (%) based on the Wait Class. The users can select the desired metric by choosing the legend in the upper-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
Wait
Provides bar chart information on major wait events by time interval. The users can check how many seconds the event occurred during that time. The users can select the desired indicator by selecting the legend at the top right. The users can also select the MIN, MAX, or AVG aggregation method using the combo box.
Wait (Count)
Provides time-based information on major wait events in a bar chart. The users can see how many times a wait event occurred at a specific time. The users can select the desired metric by choosing the legend in the top-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
Wait Class
Provides classified information about Wait Events in a Stacked Bar Chart format. The users can select the desired metric by choosing the legend in the top-right corner. Additionally, the users can select the aggregation method (MIN, MAX, AVG) using the combo box.
Performance Table
The following is an explanation of the table categories provided at the bottom when the users click on the Performance Chart.
Snapshot
The Snapshot area of the Performance Chart provides a summary of Wait Class information for Running Sessions at the specified time point, as well as SQL execution history for each session and other session information for the specified interval.
Caution
Some metrics (such as Username, Program, Module, Schema, OS User, Machine, Terminal, etc.) may not be collected depending on the version of the Tibero library used for session information collection.
SID
Session ID
Serial #
Serial number of the session
Elapsed Time
Elapsed time of the SQL currently being executed in the session
User Name
Current user name
Program
The name of the program in the session
Module
The name of the module specified by dbms_application_info.set_module
Logical Reads
The Logical Reads value of the session
Physical Reads
The Physical Reads value of the session
Execute Counts
Execute Count value for the session
Redo Entries
Redo Entries value for the session
Hard Parse
Hard Parse value for the session
Wait Event
The type of Wait Event that the session is waiting for
Wait Time
The time the session has been waiting for the Wait Event
Status
The status of the session -READY: Session ready state -RUNNING: Session is running -TX_RECOVERING: Transaction recovery in progress -SESS_CLEANUP: Session resources are being cleaned up -ASSIGNED: Thread assigned to session but not yet ready - CLOSING: Session closed -ROLLING_BACK: Slave of PE specification level transaction rolled back
State
State of the work thread -INVALID: Not initialized -NEW: Being created -IDLE: Ready to execute -RUNNING: Running -WAITING: Waiting for internal message -RECV_WAITING: Waiting for client message -STOP_BY_MTHR: Stopped by the monitoring process -DEAD: Dead state
PGA Memory (Session)
PGA memory usage of the session
SQL Trace
Whether to use SQL tracing in the session
Wlock Wait
Wait type that the session is waiting for
Audsid
Second serial number of the session
User ID
User ID information
IP Address
User connection IP address
TX_UNDO_BLK_CNT
Number of transaction undo blocks
TX_UNDO_REC_CNT
Number of transaction undo records
Command
Current SQL type being executed -0: No SQL being executed -1: SELECT -2: INSERT -3: UPDATE -4: DELETE -5: MERGE -6: CALL
Schema
Session Schema
Thr Type
Session type -WTHR: Working thread -CTHR: Control thread -LGWR: Log writing process -CKPT: Checkpoint process -LARC: Log archive -AGENT: Sequence process -MTHR: Monitoring process -DBWR: Datablock writing process -LNW: Log network writing process
SQL ID
SQL ID of the SQL being executed by the session
Child Number
Child Number value of the SQL ID being executed by the session
Prev SQL ID
SQL ID of the last SQL executed
Prev Child Number
Child Number value of the last executed SQL ID
Logon Time
The logon time of the session
Client PID
Client PID of the session
PID
The identifier of the process to which the session belongs
OS User
OS account name of the connected session
Machine
Host name of the connected session
Terminal
Terminal (TTY) information for the connected session
Action
Name of the action specified by dbms_application_info.set_module/action
Client Info
The name of the client_info specified by dbms_application_info.set_client_info
Client Identifier
Name of the client ID specified by dbms_session.set_identifier
Backup Wait
The time waited for Backup Wait
DD Wait
The time waited for DD Wait
DDL Wait
Time spent waiting for DDL Wait
Internal Wait
Time spent waiting for Internal Wait
IO Wait
Time spent waiting for IO Wait
PSM Wait
Time spent waiting for PSM Wait
Recovery Tac Wait
Time spent waiting for Recovery Tac Wait
Recovery Wait
Time spent waiting in Recovery Wait
Redo Tac Wait
Time spent waiting for Redo Tac Wait
Redo Wait
Time spent waiting for Redo Wait
Resource Wait
Time spent waiting for Resource Wait
Session Wait
Time spent waiting for Session Wait
Space Wait
Time spent waiting for space
Sql Tac Wait
Time spent waiting for Sql Tac Wait
Standby Wait
Time spent waiting in Standby Wait
Wlock Wait
Time spent waiting for Wlock Wait
Xa Wait
Time spent waiting for Xa Wait
Top Process
The Top Process category aggregates process information with high CPU and memory resource usage at the OS level for each time interval and displays the resources used by each process.
PID
The OS PID value of the process
Command
The OS command of the process
User
OS user name
CPU (%)
CPU usage at the process level
Memory
Memory usage
Running Time
Process running time
Last time
Last time of the process
Session
In the Session area of the Performance Chart, clicking the graph at the top displays a list of Running Sessions for the corresponding time interval.
SID
Session ID
Serial #
Serial number of the session
User Name
Current user name
Logon Time
Logon time of the session
Elapsed Time
Elapsed time of the SQL currently being executed in the session
Machine
Host name of the connected session
Program
The program name of the session
Module
The name of the module specified by dbms_application_info.set_module
Action
The name of the action specified by dbms_application_info.set_module/action
OS User
The OS account name of the connected session
IP Address
User connection IP address
CPU Time
CPU usage time of the session
Logical Reads
Logical Reads value for the session
Physical Reads
Physical Reads value for the session
Execute Counts
Execute Count value for the session
Redo Entries
Redo Entries value for the session
Hard Parse
Hard Parse value for the session
Backup Wait
Time spent waiting for Backup Wait
DD Wait
Time waited for DD Wait
DDL Wait
Time spent waiting for DDL Wait
Internal Wait
Time spent waiting for Internal Wait
IO Wait
Time spent waiting for IO Wait
PSM Wait
Time spent waiting for PSM Wait
Recovery Tac Wait
Time spent waiting for Recovery Tac Wait
Recovery Wait
Time spent waiting in Recovery Wait
Redo Tac Wait
Time spent waiting for Redo Tac Wait
Redo Wait
Time spent waiting for Redo Wait
Resource Wait
Time spent waiting for Resource Wait
Session Wait
Time spent waiting for Session Wait
Space Wait
Time spent waiting for space
Sql Tac Wait
Time spent waiting for Sql Tac Wait
Standby Wait
Time spent waiting in Standby Wait
Wlock Wait
Time spent waiting for Wlock Wait
Xa Wait
Time spent waiting for Xa Wait
SQL
In the SQL area of the Performance Chart, clicking the graph at the top displays a list of SQL statements executed in each session during the specified time interval. Clicking an SQL ID takes the users to the SQL Detail page for that SQL statement.
SQL ID
SQL ID of the SQL currently being executed
Child Number
Child Number value of the SQL being executed
SQL Text
SQL content
Elapsed Time
Elapsed time of the SQL currently being executed
Execute Counts
Number of times the SQL was executed
CPU Time
CPU usage time
Logical Reads
Number of blocks read by memory I/O
Physical Reads
Number of blocks read via block I/O
Redo Entries
Number of redo entries
Hard Parse
Hard Parse value of SQL
Application Wait
Time spent waiting for Application Wait
Cache Wait
Time spent waiting for Cache Wait
Cluster Wait
Time spent waiting for Cluster Wait
Concurrency Wait
Time spent waiting for concurrency
Other Wait
Time spent waiting for Other Wait
SQL Wait
Time spent waiting for SQL Wait
System IO Wait
Time spent waiting for System I/O Wait
User IO Wait
Time spent waiting for User I/O
All SQL
The All SQL area of the Performance Chart displays a list of all SQL statements executed during the time period when the graph at the top is clicked.
SQL ID | Child Number
Pairs of SQL ID and Child Number values for SQL statements being executed by the session
SID
The ID of the session
Serial #
The serial number of the session
SQL ID
SQL ID of the SQL being executed by the session
Child Number
Child number of the SQL being executed by the session
SQL Text
SQL content
Elapsed Time
Elapsed time of the SQL currently being executed
Start Time
Start time of the SQL
End Time
The end time of the SQL
Log Time
The time when the SQL execution was recorded in the system master
Machine
Host name of the connected session
Module
The name of the module specified by dbms_application_info.set_module
Program
The name of the program for the session
User Name
Current user name
OS User
OS account name of the connected session
CPU Time
CPU usage time of the session
Logical Reads
Logical Reads value of the session
Physical Reads
Physical Reads value for the session
Execute Counts
Execute Count value for the session
Redo Entries
Redo Entries value for the session
Hard Parse
Hard Parse value for the session
Backup Wait
Time spent waiting for Backup Wait
DD Wait
Time waited for DD Wait
DDL Wait
Time spent waiting for DDL Wait
Internal Wait
Time spent waiting for Internal Wait
IO Wait
Time spent waiting for IO Wait
PSM Wait
Time spent waiting for PSM Wait
Recovery Tac Wait
Time spent waiting for Recovery Tac Wait
Recovery Wait
Time spent waiting in Recovery Wait
Redo Tac Wait
Time spent waiting for Redo Tac Wait
Redo Wait
Time spent waiting for Redo Wait
Resource Wait
Time spent waiting for Resource Wait
Session Wait
Time spent waiting for Session Wait
Space Wait
Time spent waiting for space
Sql Tac Wait
Time spent waiting for Sql Tac Wait
Standby Wait
Time spent waiting in Standby Wait
Wlock Wait
Time spent waiting for Wlock Wait
Xa Wait
Time spent waiting for Xa Wait
Lock Tree
In the Lock Tree area of the Performance Chart, clicking the graph at the top displays the wait situations caused by transaction locks between sessions during that interval in a tree format.
Instance
Database instance number
SID
Session SID
Serial #
Session serial number
Elapsed Time
Running time of the session
Status
Session holder and waiter information
Session Status
Session status
Wait Time
Time waited
User Name
Session user name
Module
Session module name
Program
Session program name
Machine
Host name of the session
IP Addr
User IP address of the connection
SQL ID
SQL ID of the SQL being executed by the session
Child Number
Child Number value of the SQL Plan being executed by the session
Wait Event
The name of the wait event for the session
Type
Lock type
ID1
Lock ID1
ID2
Lock ID2
Mode
Lock mode held by the holder (Waiter is always 0)
Request
Lock mode requested by the Waiter (Holder is always 0)
Wait Detail
In the Wait Detail area of the Performance Chart, clicking the graph at the top displays the Wait Events that occurred during the past minute, and clicking a specific Wait Event displays a list of sessions where the Wait Event occurred on the right.
Wait Event Area
Name
Wait Event name
Desc
Wait Event Details
Wait Class
Wait Class Name
Count
Number of wait events
Time
Wait Event Wait Time
Wait Session Area
SID
Session ID
Serial #
Serial number of the session
Time
Wait Event Wait time
Count
Number of wait events
User Name
Current user name
Module
Name of the module specified by dbms_application_info.set_module
OS User
The OS account name of the connected session
Machine
The host name of the connected session
Program
The program name of the session
Last updated