Analysis

This chapter describes the Analysis menu, which enables period analysis of accumulated data through real-time indicator collection.

  1. Performance Analysis - Analyzes metrics related to performance.

  2. History Analysis - Analyzes trends in changes over time, such as plan changes, connection session counts, alert occurrence rates, and the number of invalid objects.

  3. Usage Analysis - The users can monitor trends in the usage of Tablespace, Filesystem, Segment, Temp Tablespace, and Undo Tablespace.

Common Features

This section describes the common features used in the submenus of the Analysis service.

Instance

This is a dropdown menu that appears when entering the Analysis submenu. The users can select the instance to monitor from this dropdown menu.

Analysis Click the dropdown menu in the upper-left corner of the Analysis menu screen.

Click the Instance dropdown menu.

When the drop-down menu appears, select the desired instance, and the monitoring information for that instance will appear on the screen.

Period Selector

The submenu of Analysis provides a Period Selector. Users can set the period for data analysis using the Period Selector. Set the period in the Period area and click the [VIEW] button on the right to view the data for the target period. By default, the period is set to 1 hour, but if a specific period is required, the users can select Custom to view data for the desired period.

Note

The Performance trend overall screen and Heatmap trend initial screen display data based on the default time.

The Period selector changes the unit of data retrieved based on the search range, and each submenu under Analysis has different rules and minimum search units.

Search range and chart data unit default rules

By default, the chart data units are supported in minutes, hours, and days, and the unit changes based on the number of data points (120).

  • Example 1: Search range of 120 minutes (2 hours) or less is displayed as minute-unit data.

  • Example 2: Search range exceeding 120 minutes (2 hours) but less than 120 hours (5 days) is displayed as hour-based data.

  • Example 3: Search range exceeding 120 hours (5 days) is displayed as day-based data.

Minimum search unit and chart data unit in the submenu

  • Example 1: Minimum search unit [minutes], chart data follows the default rule Performance Trend Alert Analysis

  • Example 2: Minimum search unit [hours], chart data is provided in time units Invalid Object Tablespace Usage Filesystem Usage Temp Usage Undo Usage

  • Case 3: Minimum search unit [day], chart data is provided in time units Heatmap Trend

  • Exception Page: Explanation of period-related actions on each page All Session Flow Segment Usage