UI usage guide

The following explains how to use the user interface (UI) elements commonly used in individual menus of the WhaTap monitoring service. Common UI elements are designed to maintain consistency across menus and allow users to quickly and intuitively access desired features. It also provides a consistent and efficient user experience. This guide helps you understand all the features of the WhaTap monitoring service more easily and use them more efficiently.

Time selector

It provides the feature to set dates and times so that users can quickly and accurately analyze the required data. The following guides you to the main features of the time selector and how to use them.

Real-time mode

This mode allows you to check the current status by updating the dashboard data in real time. When the current menu is in live mode, the date and time selection tools at the top of the screen display Live.

Real-time mode collects data at an interval of 5 seconds by default and displays it on the screen. If the time selector displays a green icon (e.g. 5 Minutes), the data is updated every 5 seconds during the query.

For example, if the time selector displays 5 Minutes, the charts or data displayed on the screen is continuously updated every 5 seconds for 5 minutes.

• You can change the data query range by selecting the green icon button.

  

• If you want to stop real-time mode and view the data at a specific time, select or the clock area.

  

Note

Real-time mode may not be supported depending on the menus and features provided.

Period setting mode (past time query)

This mode allows users to set the desired start and end times and then retrieve data for the period. To return to live mode, select .

To view a past time, you can set a desired viewing period by clicking or selecting the date and time.

Note

The maximum query period may differ depending on the provided menus and features, and the real-time mode () may not be supported.

Selecting the specific date and time

You can select the desired date and time to view the data for the period.

Changing with the keyboard

You can click the date or time and then use your keyboard to change the time.

• Press the left or right arrow keys on your keyboard to move through the step of year, month, day, hour, and minute. You can also navigate by pressing TAB or Shift + TAB keys.

• You can change the date or time to your taste by pressing the up or down arrow key on your keyboard.

• Change the time using your keyboard, and then press Enter or click outside the time selector. If you press ESC while typing, your changes is not applied.

• In Period setting mode, you can change the desired query period by selecting or . At this time, the time unit to be changed is based on the value indicated on the green icon.

Changing in the calendar

Select on the utmost right of the time selector. A window appears allowing you to select a calendar and time. You can change it by selecting the desired date and time. After changing the date and time, select Confirm.

• You can change by month by selecting or at the top of the calendar.

• You can select the desired time from the time selection box at the bottom of the calendar. Select a time and then click Confirm.

• You can change it to the current time by selecting Now.

• Dates that are grayed out cannot be selected.

Note

• If you select , the current document page appears.

• Maximum query period may differ depending on the menus and features provided.

Selecting a predefined query range

It provides the feature to select a predefined query range to enable quick and efficient data retrieval. Select the green button in the time selector.

The options to select from short term to mid term, or a specific date. Select the desired options and then click or . You can change the time based on the selected query range unit.

The Last Time Searched option allows you to select a list of recently searched times.

Note

The list of predefined query ranges that can be selected may differ depending on the menus and features provided.

Changing by paste

After copying the time from the time selector, you can paste it after changing the text value to a desired value.

1. In the time selector, press Ctrl + C to copy from the year, month, day, and time area.

2. Paste it into the text editor and then change it to your desired date and time.

3. Copy the changed date and time in the text editor.

4. Paste by pressing Ctrl + V in the time selector.

Note

• For the date and time format that can be pasted, see the following. YYYY/MM/DD HH:MM ~ YYYY/MM/DD HH:MM

  e.g. 2024/12/10 09:00 to 2024/12/11 13:00

• If the date and time format is incorrect, it is not pasted.

Checking the session information details

Checking the session information details

If you select a session in the Active sessions tab, the Session detail window appears. You can see the information details about the selected session.

• The session information is viewed in real time by default. If you select in the time selector, you can stop a real-time view and see the data based on the paused time. To refresh data while pausing a real-time view, select .

• Kill Session: You can stop the selected session. If the Session kill window appears, enter the password (Parameter Key) and then select Apply.

  Note

  This feature is only available in real-time viewing mode.

• Session history: You can go to the Session History menu to see the records of the selected session.

  Note

  For more information about Session History, see the following.

• Session Stat: It provides various performance metrics and statistical information for the selected session. It includes the type and number of tasks performed in the session, resource usage, and more.

• Delta / Sigma: The change rate and statistical analysis information for the selected session appear. You can check the amount of change in session activities.

• Session Info: You can see the basic information of the selected session and the information details including the status.

• Wait Info: The waiting event and waiting time of the selected session are provided. You can also see information about the waiting events that occur when the database system is waiting to execute a specific task.

• SQL Text / Plan: You can see the SQL query statements and plans of the selected session. For more information, see the following.

See query details

• View SQL Statistics: You can go to the SQL statistics menu where you can check statistical information related to the SQL query statement.

• Runtime Plan: It provides the execution plan and runtime information for a selected SQL query. It provides the information details such as execution count, average execution time, and average physical reads.

• Explain Plan: It displays the execution plan predicted by the optimizer. It provides information such as cost, job, object name, and cardinality.

• Plan History: You can check the history of the execution plans of the SQL queries executed in the database.

• Bind Capture: You can see the values ​​of the bind variables used in SQL queries executed in the database. This allows you to see actual content of query executions.

  Note

  This is a value captured in the database (v$sql_bind_capture), not a bind value executed in real time. If the number of cases is too large, it displays up to 100.

Viewing the default plan

When creating the default plan user file, you can configure the agent to automatically view the plan by using the predefined DB information. After checking the box for Default plan inquiry, search for the plan through the specified DB connection information as follows.

Linux

1. Add the plan_db option to the agent configuration (whatap.conf) file and then enter the DB name.

   whatap.conf

   plan_db=(dbname)

2. After configuring the DB, use the planuid.sh script to set the user and password.

   ./planuid.sh user pwd

   Note

   If the user (user) and password (pwd) include special characters, add backslashes (\) before each special character.

   e.g. user$example → user\$example

Windows

1. Add the plan_db option to the agent configuration (whatap.conf) file and then enter the DB name.

   whatap.conf

   plan_db=(dbname)

2. After configuring the DB, use the planuid.bat script to set the user and password.

   planuid.bat user pwd

Setting the table columns

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

Note

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

• In the 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 list, select the items to add as table header columns. To select all items, select Select All.

Deleting columns

From the list, unselect the columns to delete. Alternatively, select on the right of the item to delete from the list.

Changing the column order

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

Initializing the configuration

To cancel all changes and reset them, select Initialized.

Filtering the table data

1. Select 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.