Performance Analysis

Performance Analysis allows the users to check various performance-related metrics.

Performance Trend

After checking the long-term trend using the Overall menu, the users can use the Time Slice feature to view all indicator information at a specific point in time.

Time Slice

The users can set the viewing period for each submenu of Analysis. Click the Time Slice button at the top of the screen to move to the Time Slice creation window.

1. Select the time period for the Time Slice.

2. Select the Time Unit to divide the Time Slice and click View.

3. Select the Time Slice divided by the Time Unit within the interval to open the screen for that Time Slice.

Note

Time Unit values must be natural numbers between 1 and 99.

Top N Performance

The users can check which SQL generated the most metrics the users are interested in, such as Physical Reads and Hard Parse Count.

Heatmap Trend

The users can view the trend of the set metrics through a Heatmap and link to the Performance Trend or Top N Performance page for the desired period for further analysis.

Note

When Tibero Wait Event metrics show a Count of 0 or higher but a Time of 0

The Wait Event Time collected by the Tibero library is recorded down to the nanosecond level, but the metric aggregation and output are performed in microseconds. Therefore, if only nanosecond-level Waits occur, the Wait Count may be greater than 0, but the Wait Time will be displayed as 0.