Skip to main content

Checking the statistical data

SQL statistics​

Home > Select Project > Stat/Report > SQL statistics

It provides the statistical data for each DB. With the time series charts for each SQL, you can see the occurrence time and performance.

For more information about SQL statistics, see the following video clip.

Note

This statistics page is provided based on the session data collected every 5 seconds and the SQL texts. There may be errors depending on the collection method.

SQL Statistics

Set the number 1 Time and Instance and then select Search icon. To classify and view data by usage category, select the desired tab from number2.

Query-based execution trend​

On the utmost left for each item of the table, select Leader line 3 ►. A chart appears that displays the number of executions every 5 minutes and the average execution time of the query statement.

Previewing the query​

Query preview

You can preview the query statement by moving the mouse pointer to the sql column in the search results list.

See details​

If you select sql from the searched result list, the SQL details window appears.

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.

  • Default Bind: You can bind the part set as a variable in the query sentence to the default value.

  • Reset Bind: You can release the bound default value and check the variable.

  • Formatting: You can improve readability by applying indentation and formatting to a SQL query statement.

  • Plan: To check plan information, enter DB Name, User Name, and Password, and then select Search icon.

  • If you select Vertical split icon on the upper right of the screen, the Query and Plan sections are placed left to right.

  • If you select Vertical split icon on the upper right of the screen, the Query and Plan sections are placed up to down.

Tablespace Size​

Home > Select Project > STAT/REPORT > Tablespace Size

Tablespace Size

Set the time and instance and then select Search icon. Depending on the settings, the searched data is provided in a chart and a table.

  • Time

    • If you select the green icon, you can search up to 3 weeks.
    • With the lookup period selected, select Left arrow icon or Right arrow icon. Then you can change the lookup time at the set time intervals.
    • If you select the date and time, you can set the desired time in detail. After configuration, select OK.

  • Instance: You can select an instance that is connected with the project.

  • Tablespace Size Chart

    The maximum capacity and usage trend are provided for each tablespace in a cumulative chart. You can check the trend from 1 day up to 3 weeks. You can change the chart data by selecting Total or Used on the upper right corner.

  • Tablespace Detail

    The searched data is provided in a table. You can compare the start times and end times based on the lookup time, and you can see the change in data usage size.

    • To check the details in a tablespace, select Right arrow icon located on the left of each item.
    • If you select each item in the table header, you can sort the table by the selected item.

SGA size​

Home > Select Project > STAT/REPORT > SGA Size

You can monitor timely changes by saving summaries of SGA that is an server memory area.

  1. Set the time to search in Time.

  2. Select an instance name to view the trend data of the instance.

  3. Select Search icon.

Note

You can select a lookup time (up to 3 weeks). Select the clock display area to query a random date and time. If you click the date and time text area, the selectable options for the date and time appear.