In the event of a particular module’s (up to 5) performance degradation, it provides the function through which you can compare with the previous execution history.

The Search Condition window configuration is as follows.

Search Condition	Description
	Enter or select the target instance for analysis.  For selection convenience, the autocomplete function is available.  When you click on the drop-down menu, a list of all the instances will appear.
	Indicates the instance selected in Find Instance.  You can also directly selecte the target analysis instance from the corresponding screen.
	Used for module search.  When you click on the “Search” button without entering the module name in the Find Module, then the whole list of module names will be output at the bottom. The Find Module input rules are as follows. Not case-sensitive. Insert ‘%’ at the front and the end of the keyword, and then perform a LIKE search.
	Provides a list of modules selected in the Find Module window. Maximum 5
	Set the comparison sections.
	Set the standard section. In general, the section in which the performance was normal is set as the Base Section.

The window configuration is as follows.

Provides the summary information of the search conditions entered in Search Condition.

Note. If you want to see the previous state of the Search Condition, click on the  button.

Provides summary information of comparing two sections based on the module execution time and the execution count of the SQLs executed in the corresponding module.

• Elapsed Time(Sec): Provides the CPU Time and Wait Time information by each Module
• Executions: Provides SQL Execution Count by each Module

Elapsed Time(Sec) Comparison Window

Executions Comparison Window

• Provides the difference between the two sections’ total Elapsed Time.
• Provides the Top-10 SQL ID, whose Elapsed Time difference is high compared to the Base

Gap Analysis Window

Provides information of the SQL selected (bar graph click) in the Gap Analysis.

SQL Info Window

Compares the main performance information of the SQL selected (bar graph click) in the Gap Analysis.

SQL Stat Comparison Window

SQL Stat Comparison Grid Column

SQL Stat Comparison Grid Mouse Right-Click Menu

The mouse right-click menu is as follows.  For more information, please reference “Appendix. Grid Mouse Right-Click Menu UI”.

Compares the wait time per 1 execution of the SQL selected (bar graph click) in the Gap Analysis.

SQL Wait Time Comparison Window

In the event of a particular program’s performance degradation, it provides the function through which you can compare with the previous execution history.

The Search Condition window configuration is as follows.

Search Condition	Description
	Enter or select the target instance for analysis.  For selection convenience, the autocomplete function is available.  When you click on the drop-down menu, a list of all the instances will appear.
	Indicates the instance selected in Find Instance.  You can also directly selecte the target analysis instance from the corresponding screen.
	Used for program search.  When you click on the “Search” button without entering the program name in the Find Program, then the whole list of program names will be output at the bottom. The Find Program input rules are as follows. Not case-sensitive. Insert ‘%’ at the front and the end of the keyword, and then perform a LIKE search.
	Set the comparison sections.
	Set the standard section. In general, the section in which the performance was normal is set as the Base Section.

The window configuration is as follows.

Provides the summary information of the search conditions entered in Search Condition.

Note. If you want to see the previous state of the Search Condition, click on the  button.

Provides summary information of comparing two sections based on the program execution time and the execution count of the SQLs executed in the corresponding program.

• Elapsed Time(Sec): Provides the CPU Time and Wait Time information by each Program
• Executions: Provides SQL Execution Count by each Program

Elapsed Time(Sec) Comparison Window

Executions Comparison Window

• Provides the difference between the two sections’ total Elapsed Time.
• Provides the Top-10 SQL ID, whose Elapsed Time difference is high compared to the Base

Gap Analysis Window

Provides information of the SQL selected (bar graph click) in the Gap Analysis.

SQL Info Window

Compares the main performance information of the SQL selected (bar graph click) in the Gap Analysis.  .

SQL Stat Comparison Window

SQL Stat Comparison Grid Column

SQL Stat Comparison Grid Mouse Right-Click Menu

The mouse right-click menu is as follows.  For more information, please reference “Appendix. Grid Mouse Right-Click Menu UI”.

Compares the wait time per 1 execution of the SQL selected (bar graph click) in the Gap Analysis.

SQL Wait Time Comparison Window

In the event of a poorly performing section is generated, it provides a function through which you can compare with the previous dates’ corresponding time.

The Search Condition window configuration is as follows.

Search Condition	Description
	Enter or select the target instance for analysis.  For selection convenience, the autocomplete function is available.  When you click on the drop-down menu, a list of all the instances will appear.
	Indicates the instance selected in Find Instance.  You can also directly selecte the target analysis instance from the corresponding screen.
	Set the analysis target Peak date.
	Set the time period within the analysis target Peak date.
	Set the comparison date. 1 day before the analysis date 3 days before the analysis date Same as the Analysis Date (3 days) Assigned by the User (Maximum 3 days)

The window configuration is as follows.

Provides the summary information of the search conditions entered in Search Condition.

Note. If you want to see the previous state of the Search Condition, click on the   button.

Provides the hourly comparison information of the Wait Time and Active User Session indicators.

• Total Wait Time Tab: Compares the Hourly Total Wait Time of the Peak Date and the comparison date(s).
• Active User Session Tab: Compares the Hourly Average Active User Sessions Values of the Peak Date and the comparison date(s).

Total Wait Tab Window

Active User Session Tab Window

• Provides a function through which you can analyze a particular time section’s Wait Time Gap of the Peak Date and the comparison date.

Overall Tab Window

Compares and analyzes the entire section’s Wait Time Gap for the Peak Date and the comparison date.

Note. When there are 2 or more comparison dates, then it is compared in the order of most recent date.

Selected Time Tab Window

Compare and analyzes the hourly Wait Time Gap of the Peak Date and the comparison date.

Note. When you first click on the Selected Time Tab, it automatically compares the the time window at which the Wait Time is the highest within the Peak Date.

Wait Time Total Difference

Provides the difference in the Wait Time.

Note1. Peak Date’s Wait Time (Sec) – Comparison Date’s Wait Time (Sec)
Note2. The Total Tab provides the difference between the entire sections, and the Selected Time Tab provides the difference between each selected time window.

Grid Column (Common)