Skip to main content

Wait analysis

Info

This document has been created based on the Oracle Monitoring V2. For the Oracle monitoring V1 document, see the following.

Home > Select Project > Analysis > Wait Analysis

You can check in which wait event the active session is waiting and which wait events occur frequently. Active sessions collected every 5 seconds can be analyzed from the wait perspective.

Note

  • This function is supported in DBX agent 1.9.0 or later.

  • The collected wait data includes wait_event and wait_event_type in the pg_stat_activity view. For more information about the metric, see the following.

Basic screen guide​

Wait analysis

Select the Time and Instance to view. You can see the wait data corresponding to the set time and instance. If there are active sessions that frequently wait (delay) during the query period, it can be used to analyze what types of wait events occurred.

Wait Event Top 5

In Wait Event Top 5, you can see which wait events occurred most frequently. Using the above image as an example, the most frequently occurred type of wait event is Lock. If you select the number1 detailed time in the graph chart, you can view the active sessions in the time and check the SQL statements in which the wait events occurred.

Note

  • When you select the instance column in the Active Session section list, the Monitoring a Database Instance menu appears. For more information about Monitoring a Database Instance, see the following.

  • In the Active Session list, if you select a session, the Session detail window appears. For more information about the Session detail windows, see the following.

  • When you select the query column in the Active Session list, the SQL details window appears. For more information about the SQL details windows, see the following.

Filtering the table data​

Filter

  1. Select Filter icon on the upper right of the table.

  2. Select a column header and a condition in the table.

  3. Enter a desired value in the Enter conditions field.

  4. Select Save.

Setting the table columns​

You can hide the table header columns or add any of them. You can also change the column order. Select Column icon.

Column Settings

Note

  • After configuration, select Confirm to apply the settings in the table.

  • In the number 3 search bar, enter text to search the desired columns. Only the columns that meet the entered text are displayed.

  • Images may differ depending on the product, project, or menu.

Adding columns​

From the Number 1 list, select the items to add as table header columns. To select all items, select Select All.

Deleting columns​

From the number 1 list, unselect the columns to delete. Alternatively, select Delete icon on the right of the item to delete from the number 2 list.

Changing the column order​

Drag an item to reposition from the number 2 list, and then move it to the desired position.

Initializing the configuration​

To cancel all changes and reset them, select Reset icon Initialized.