Skip to main content

Session History

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 > Session History

In Session History, you can see what has been performed in a specific session during the query period. It provides information that allows you to check how much resource has been used for SQL for a long-running session and analyze the causes.

Basic usage guide​

You must enter the session number (Process ID) to monitor as a required value, but it is more efficient to enter through the Monitoring a Database Instance menu.

  1. Go to Dashboard > Monitoring a Database Instance.

  2. Select a session that is running and not ended for a long time.

    Monitoring a Database Instance

  3. If the Session detail window appears, select Session history.

    Session History

The Session History menu appears that has searched the process ID (PID) of the selected session.

Session History

Active session data collected every 5 seconds from the selected session is used to construct a chart and its list and provide information that can be used for analysis.

  • Wait: You can see the percentage of waiting events through a chart.

  • Cpu: You can see the change trend in CPU usage through the chart.

  • Memory: You can see the change trend in memory usage through the chart.

  • Disk I/O: You can see the change trend in disk usage through the chart.

If you select the query column on the utmost right of the list, the SQL details window appears where you can see the SQL statement. It contains full texts and plan information for the selected query.

See query details​

SQL 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.

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.