rt_title2

4. Resource Monitoring

Note. The difference between Frame and Tool is in whether or not it can be docked or not. Only Frame items can be docked.

Back To Top

Common UI

The Common UI’s provided in Tool or Frame are as follows.

Back To Top

SUB) Tool Common UI

Item Description
 28 Maximizes the Frame or Tool
 29 Closes the Frame or Tool
Instance List This area displays a list of all the instances currently being monitored.  When you click on the instance name, it provides information regarding the corresponding instance.
 30 Creates an identical window.
 31 Provides the Auto refresh enable/disable function.

  • Check : Enables Auto Refresh
  • Uncheck: Disables Auto Refresh
 32 In Auto Refresh Enable state, you need to set the Refresh cycle.
 33 Displays the Last Refresh time.
 34 Provides the Manual Refresh function.  Only operates in Auto Refresh Disable state.
 35 Instance List navigation arrows

Back To Top

SUB) Frame Common UI

Item Description
 36 Maximizes the Frame or Tool
 37 Closes the Frame or Tool

Back To Top

SUB) Overview

The All Statistics Tool provides the average value (per second) of all the performance indicators and wait events’ workload.

  • Work Path: Select Menu -> Tools -> All Statistics

The window configuration is as follows.

38

Back To Top

SUB) Instance List

The Instance List provides a list of all the instances currently being monitored.

Back To Top

SUB) Stats Area

The Stats Area provides the current value or the generated value per second of all the performance indicators.

Note. In general, for performance indicators whose names contain the word “current” such as logons current and opened cursors current, and others such as pga memory and pga memory max, the current value is given.

Back To Top

SUB) Wait Event Area

The Wait Event Area provides the wait time per second of all the wait events currently being generated.

Back To Top

SUB) Grid Column

Column Name Description
Name
  • Stats Area: Performance Indicator Name
  • Wait Event Area: Wait Indicator Name
Value/sec
  • Stats Area: Generated Value Per Second
  • Wait Event Area: Wait Time Per Second

Back To Top

SUB) Top-Down Real Time Diagnostics

When you double click the individual Name within the Stats Area, you will be connected to another window according to the performance indicator as shown below.

Performance Indicator Connection Window Content Provided
Active sessions Session Manager Tool A list of Active sessions
(background session included)
Active user session Session Manager Tool A list of Active sessions

(background not included)

Total sessions Session Manager Tool A list of all the sessions currently connected to
Long idle sessions Session Manager Tool A list of sessions whose inactive state has exceeded 3,600 seconds
Oracle Statistics Top Session (Stat) Window Top 20 sessions of the corresponding performance indicator

Note. The Oracle Statistics refers to the performance indicators that relate to V$STATNAME. For more information regarding the Session Manager Tool, please reference the “Chapter 5 Session Manager Tool” section. For more information regarding Top Session (Stat) Window, please reference the “Chapter 5 Top Session (Stat) Window” section.

When you double click the individual Name within the Wait Event Area, you will be connected to another window according to the wait events as shown below.

Wait Event Description Connection Window
Lock waiting sessions & Enqueue related Wait Events Provides the relationship between Holder and Waiter in a lock tree. Lock Tree Frame
All Wait Events excluding Enqueue Provides the top 20 sessions of the corresponding wait event. Top Session (Event) Window

Note. For more information regarding the Lock Tree Frame, please reference “Chapter 5 Lock Tree Frame” section. For more information regarding the Top Session (Event) Window, please reference “Chapter 5 Top Session (Event) Window” section.

Back To Top

SUB) 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”.

Item Description
Export Excel Downloads the grid content on an excel file.
Copy(To Clipboard) Makes a copy of the grid content.
Show/ Hide Columns Selects the columns to be displayed on the grid.
Filter On Enables the Filtering function.
Multiple Sort On Sorts based on 2 or more column values.
Save Image Saves the grid content as an image.

Back To Top

SUB) Overview

The CPU, Memory (Multi) Frame provides the CPU and memory related information of all the database servers currently being monitored.

  • Work Path: Select Menu -> Docking Frame -> CPU, Memory (Multi)

The window configuration is as follows.

123

Back To Top

SUB) Use Animation

The Use Animation selects the bar chart expression method.

Item Description
 39 Draws again from 0
 40 Draws only the changes

Back To Top

SUB) Grid Column

Column Name Description
Instance Name Instance name
CPU CPU usage (%)
Sys CPU Kernel mode CPU usage (%)
User CPU User mode CPU usage (%)
I/O Wait CPU I/O wait CPU usage(%)
Idle CPU Idle CPU (%)
Used Memory Memory usage(%)
Total OS Memory (GB) Total memory Size
Free OS Memory (GB) Free memory Size

Back To Top

SUB) Top-Down Real Time Diagnostics

When you click the instance name or the CPU related values, you will be connected to the corresponding instance’s Top Process (CPU) Window; and when you click the memory related values, you will be connected to the Top-Process (Memory) Window.  For more information, please reference “Chapter 5 Top-Process Window” section.

Back To Top

SUB) 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”.

Item Description
Export Excel Downloads the grid content on an excel file.
Copy(To Clipboard) Makes a copy of the grid content.
Show/ Hide Columns Selects the columns to be displayed on the grid.
Filter On Enables the Filtering function.
Multiple Sort On Sorts based on 2 or more column values.
Save Image Saves the grid content as an image.

Back To Top

SUB) Overview

The CPU, Memory (Group) Frame provides the CPU and memory usage of all the database servers currently being monitored.

  • Work Path: Select Menu -> Docking Frame -> CPU, Memory (Group)

The window configuration is as follows.

41

Back To Top

SUB) Display Method

There are 3 types of display methods.

Item Description
 42 Displays the CPU and memory usage sequentially by each database server.  (Default Setting Value)
 43 Displays only the CPU usage of the database servers.
 44 Displays only the memory usage of the database servers.
 7 Displays a separate CPU usage rate of the Oracle Sessions and the Non-Oracle sessions.
6

Back To Top

SUB) Exclude I/O wait

The Exclude I/O wait determines whether I/O wait usage should be included in the CPU usage or not.

Item Description
 45 I/O wait usage is not included in the CPU usage.
 46 I/O wait usage is included in the CPU usage.

Back To Top

SUB) Top-Down Real Time Diagnostics

When you click on the CPU usage bar chart, you will be connected to the corresponding instance’s Top Process (CPU) Window, and when you click the memory related values, you will be connected to the Top-Process (Memory) Window. For more information, please reference “Chapter 5 Top-Process Window” section.

Back To Top

SUB) Overview

The CPU, Memory (Single) Frame provides the CPU and memory information regarding a single database server.

  • Work Path: Select Menu -> Docking Frame -> CPU, Memory (Single)

The window configuration is as follows.

47

Back To Top

SUB) Window Description by Element

Item Description
 48 Displays the CPU usage.  Click, and you will be connected to Top Process(CPU) Window.  For more information, please reference  “Chapter 5 Top-Process Window” section.
 49 Displays the memory usage.  Click, and you will be connected to Top Process(Memory) Window.  For more information, please reference  “Chapter 5 Top-Process Window” section.
 50 I/O wait usage is not included in the CPU usage.
 51 I/O wait usage is included in the CPU usage.
 52 Displays the User, Sys and  I/O wait CPU usage.  The I/O wait usage will be displayed only when the Exclude I/O wait is unchecked.
 53 Provides the Total memory size and the free memory size.
 54 Provides a list of instances.

  • Trend View: Provides a list of all the instances currently being monitored.
  • RAC View: Provides a list of instances within the corresponding RAC Group.
  • Single View: Does not provide the Instance Name combo box.

Back To Top

SUB) Overview

The SGA Info Frame provides the size of the main components within the SGA.

Note. Provides the same content as the SQL> show sga execution result.

  • Work Path: Select Menu -> Docking Frame -> SGA Info

The window configuration is as follows.

55

Back To Top

SUB) Window Description by Element

Item Description
Instance Name Provides a list of instances.

  • Trend View: Provides a list of all the instances currently being monitored.
  • RAC View: Provides a list of instances within the corresponding RAC Group.
  • Single View: Does not provide the Instance Name combo box.

Back To Top

SUB) Grid Column

Column Name Description
SGA Name SGA component name
Value (MB) SGA component size

Back To Top

SUB) 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” section.

Item Name
Export Excel Downloads the grid content on an excel file.
Copy(To Clipboard) Makes a copy of the grid content.
Show/ Hide Columns Selects the columns to be displayed on the grid.
Filter On Enables the Filtering function.
Multiple Sort On Sorts based on 2 or more column values.
Save Image Saves the grid content as an image.

Back To Top

SUB) Overview

The Trend Chart Frame provides the trends on the workload and wait time of performance indicators.

  • Work Path: Select Menu -> Docking Frame -> Trend Chart

The window configuration is as follows.

56

Back To Top

SUB) Performance Statistics Name

The Performance Statistics Name displays the names of all the performance indicators currently being monitored. When you click the corresponding area, the Stat Change Window will pop up. The Stat Change Window is used to change the performance indicator and the window configuration is as follows.

57

Stat Change Window Tab Configuration

Item Description
Stat Provides a list of performance indicators.

  • All performance indicators corresponding to V$STATNAME
  • Indicators provided by MaxGauge
    • Active sessions (Active session count, background session included)
    • Active user session (Active session count, background session excluded)
    • Lock waiting sessions (Lock wait session count )
    • Total sessions (Total session count)
  • Long idle sessions (Number of sessions whose inactive state has exceeded 3,600 seconds)
Event Provides a list of wait events.

  • All wait events provided by V$EVENTNAME
OS Provides a list of OS main performance indicators.

Auto-complete Function

The Auto-complete function is available for your convenience in the indicator name search. When you start typing into the Stat Change Window’s input box, a list of indicators containing the word you typed in will appear. The following is an example of a “cursor” related performance indicator name search.

58

Back To Top

SUB) Graph Area

The Graph Area provides the trends on workload and wait time of performance indicators.  You can simultaneously monitor multiple instances.

Display Method

  • When there are 4 or less monitoring target instances, the stacked line chart format is used.

59

  • When there are 5 or more monitoring target instances, the line chart format is used.

60

(Stacked) Line Chart UI

When you put the mouse over the graph line, the value of the corresponding point will be displayed.

61

Alarm Generation

When it meets the alarm conditions set for the performance indicator, the window color will change.  If it meets the warning condition, it becomes yellow, and if it meets the Critical condition, it becomes red.

6263

Note. For more information regarding performance indicators and various types of alarm settings, please reference “MaxGauge Configuration Manual”.

Back To Top

SUB) Chart Type Change

The Chart Type Change allows you to change the chart type of the corresponding chart. The default value is the line chart. When you click 64 icon, it changes into a bar chart, and when you click 65 icon, it changes back to a line chart.

66

Back To Top

SUB) Scale Up

The next icon is used when you want to expand the view of a particular indicator for a close-up monitoring. When you click 67 icon, it will only display an expanded view of the corresponding indicator on the Trend Chart.

68

When you click the 69 icon, it returns to its previous state.

Back To Top

SUB) Menu

The following menu options are provided.

Change Visible Instance List

Select a list of instances to be displayed on the Graph Area.

  1. Click on the Change Visible Instance List button
  2. Uncheck any instances that you do not want to be displayed on the Graph Area.

8

Note. If there are more items to uncheck, then use the Invert button. When you click the Invert button, it will uncheck the items that were checked, and check the unchecked items.

Back To Top

SUB) Option

To use the option function, first put your mouse over the Trend Chart Frame and click the option button 71 on the top right corner. The Trend Chart Frame provides the following options.

  • Change Visible Instance List
  • Change Chart(Bar <-> Line)
  • Legend On
  • Display Option

Change Visible Instance List

This function is similar to the Menu->Change Visible Instance List in the Graph Area except that this targets all the indicators on the Trend Chart.

Change Chart(Bar <-> Line)

This function is similar to the bar chart icon and the line chart icon in the Graph Area except that this targets all the indicators on the Trend Chart. 

Legend On

The Legend On will display the instance names and values within the Graph Area , even on a line chart format.

72

Legend Potison

If the Legend is turned on, then designate a place in which the legend is to be displayed. There are 3 positions to choose from – Top, Right, or Bottom – and the default value is the right position. Display Option

The Display Option window configuration is as follows.

73

  • Change All: When you click theOriginal Color button, it changes to the default color. When you set theThickness value, it changes theThickness value of all the instances at the same time.
  • Instance Individual Setting: You can set the color and thickness by each instance.
  • Line Thickness Description: Displays the legend for line thickness.
  • Set up arrangement:: Sets the index number to be displayed on the Trend Chart. The default value is 6 (2 x 3), and  can display up to 16 (4 x 4).

Back To Top

SUB) Top-Down Real Time Diagnostics

The Top-Down Real Time Diagnostics provides the function of tracing the top sessions or processes.

Line Chart & Legend Off

  1. Double-click anywhere on the Graph Area.
  2. The Top Session (Stat) Window will appear on the center of the window. For more information on the corresponding window, please reference “Chapter 5 Top Session (Stat) Window”

74

Note. The content presented on the window is information on the first instance’s top sessions or processes.

Bar Chart & Legend On (Line Chart)

9
10

  1. Click on the bar area of the bar chart or the instance name on the line chart.
  2. The Top Session (Stat) Window regarding the corresponding instance will appear on the center of the window. For more information regarding the corresponding window, please reference  “Chapter 5 Top Session (Stat) Window”

11

Back To Top

SUB) Connection Window by Indicator

Statistics

The connection window by performance indicator are as follows.

Performance Indicator Connection Window Content Provided
Active sessions Session Manager Tool A list of Active sessions
(background session included)
Active user session Session Manager Tool A list of Active sessions

(background not included)

Total sessions Session Manager Tool A list of all the sessions currently connected to
Long idle sessions Session Manager Tool A list of sessions whose inactive state has exceeded 3,600 seconds
Oracle Statistics Top Sessoin (Stat) Window Top 20 sessions of the corresponding performance indicator

Note. The Oracle Statistics refers to the performance indicators that relate to V$STATNAME.  For more information regarding the Session Manager Tool, please reference the  “Chapter 5 Session Manager Tool” section.   For more information regarding Top Session (Stat) Window, please reference “Chapter 5 Top Session (Stat) Window” section.

Wait Event

The connection windows by Wait events are as follows.

Wait Event Description Connection Window
Lock waiting sessions & Enqueue related Wait Events Provides the relationship between Holder and Waiter in a lock tree. Lock Tree Frame
All Wait Events excluding Enqueue Provides the top 20 sessions of the corresponding wait event. Top Session (Event) Window
Fixed-up type of wait events among the gc related wait events Provides sessions which are waiting on the placeholder wait events of the fixed-up wait events.
For example, if you select the ”gc cr grant 2-way” fixed-up wait event, it provides a list of all the sessions waiting on the ”gc cr request” and ”gc cr multi block request”.
Top Session (Event) Window

Note. For more information regarding the Lock Tree Frame, please reference “Chapter 5 Lock Tree Frame” section.  For more information regarding the Top Session (Event) Window, please reference “Chapter 5 Top Session (Event) Window” section.

Back To Top

SUB) Overview

The Total Wait Frame provides the trends on the total wait time by instance and the wait time by wait event.

  • Work Path: Select Menu -> Docking Frame -> Total Wait

The window configuration is as follows.

78

Back To Top

SUB) Graph Area

The Graph Area provides the wait time information by instance in two types of charts.

  • Line Chart: You can check the overall trends of the wait time by instance.
  • Stacked Bar Chart: You can check the wait time by class and by instance.

Note. The default value is the line chart.

Back To Top

SUB) Graph Enable/Disable

This provides the graph display On/Off function by the use of a check box located in front of the Instance List.

Note. The default value is On mode.  If you click again, it becomes Off mode.

Back To Top

SUB) Instance List

The Instance List provides a list of all the instances currently being monitored.  When you click on an instance, it displays the wait events information of the corresponding instance in the Wait Event Area. 

Back To Top

SUB) Chart Type Change

This function allows you to change the graph display method.  When you click the 79 icon, it will change to a stacked bar chart format.

80

The individual series on the stacked bar chart refers to the wait class, by using the check box in front of each wait class name, it provides the On/Off function in regards to the corresponding series.  When you click the 81 icon, it will change to line chart format.

Back To Top

SUB) Menu

The following function is provided in the Menu.

Legend Off

For a line chart, it hides the legend. This function is only available only when it is in a line chart format.

Back To Top

SUB) Instance Name

The Instance Name provides a list of instances currently being monitored.

Column Name Description
Trend View Provides a list of all the instances currently being monitored
RAC View Provides a list of instances within the corresponding RAC Group.
Single View Does not provide the Instance Name combo box.

Back To Top

SUB) Grid Column

Column Name Description
Event Name Wait Event name
Wait Time/Sec Wait time per second (value/sec)

Back To Top

SUB) 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”.

Item Description
Export Excel Downloads the grid content on an excel file.
Copy(To Clipboard) Makes a copy of the grid content.
Show/ Hide Columns Selects the columns to be displayed on the grid.
Filter On Enables the Filtering function.
Multiple Sort On Sorts based on 2 or more column values.
Save Image Saves the grid content as an image.

Back To Top

SUB) Overview

The 24 Hour Trend Frame provides the last 24 hour performance trends.

  • Work Path: Select Menu -> Docking Frame -> 24 Hours Trend

The window configuration is as follows.

82

Note. The performance trends data utilizes the 10 minute summary table.  Therefore, you cannot set the refresh cycle and instead, it automatically refreshes every 10 minutes.

Back To Top

SUB) Graph Area

The Graph Area provides the performance trends graph of the instance(s).

Note. When only 1 instance is selected, then the AVG/MAX trend of that one instance is provided.  When “All” is selected, the AVG (or MAX) trends of all instances are provided.

Back To Top

SUB) Instance Name

The Instance Name provides a list of instances currently being monitored and the “All” items as well.

Column Name Description
Trend View Provides a list of all the instances currently being monitored and the “All” items.
RAC View Provides a list of instances within the corresponding RAC Group and the “All” items.
Single View Does not provide the Instance Name combo box.

Back To Top

SUB) When Instance Name “All” is Selected

When you select “All”, the last 24 hour trends of all the instances registered in the Instance Name combo box is provided and the window will change as shown below.

83

Back To Top

SUB) Individual Instance Name vs. All

The difference between selecting an individual instance name or “All” in the Instance Name combo box is as follows.

Category When Individual Instance Name is Selected When All is Selected
Graph Area Provides AVG and MAX values in a stacked line chart format. Provides AVG (or MAX) values of instances in a stacked line chart format.
Legend Area Provides AVG and MAX values. Provides AVG (or MAX) values of instances.
84 None Provides:

  • AVG: 10 minute AVG value
  • MAX: MAX value during the last 10 minutes.

Back To Top

SUB) Stat Change

You can change the performance indicator either by clicking the performance indicator name or the 85 button.  The changeable performance indicators are as follows.

Item Description
Stat

86

Provides a list of performance indicators.

  • All performance indicators corresponding to V$STATNAME
  • Indicators provided by MaxGauge
    • Active sessions (Active session count, background session included)
    • Active user session (Active session count, background session excluded)
    • Lock waiting sessions (Lock wait session count )
    • Total sessions (Total session count)
    • Long idle sessions (Number of sessions whose inactive state has exceeded 3,600 seconds)
Event Provides a list of wait events.

  • All wait events provided by V$EVENTNAME
OS Provides a list of OS main performance indicators.

Back To Top

SUB) Overview

The 24 Hour Trend Comparison Frame allows you to compare today’s performance trends against another date.

  • Work Path: Select Menu -> Docking Frame -> 24 Hours Trend Comparison

The window configuration is as follows.

87

Note. The performance trends data utilizes the 10 minute summary table. Therefore, you cannot set the refresh cycle and instead, it automatically refreshes every 10 minutes.

Back To Top

SUB) Graph Area

The Graph Area provides the performance trends graphs of today and of the comparison date.

Back To Top

SUB) Date Input & Calendar

You can select the comparison date by either entering the date or using the calendar.

Back To Top

SUB) Calendar UI

88

Item Description
 89 Sets the comparison date as “Yesterday”.
 90 After selecting the comparison date, it begins the search process.
 91 Confirms the selected comparison date.
 92 Cancels the selected comparison date.

AVG/MAX

Item Description
 93 Provides 10 minute AVG Value.
 94 Provides MAX value during the last 10 minutes.

Back To Top

SUB) Stat Change

This function is the same as the Stat Change button on the 24 Hours Trend Frame.

Back To Top

SUB) Retrieve

Once you have entered the comparison date or selected it on the Calendar UI and clicked the “OK” button, you can begin the search process by clicking the “Retrieve” button. If you have already clicked the “Retrieve” button from the Calendar UI, you do not need to click this button again.

Back To Top

SUB) Date Area

The Date Area displays the comparison date.

Back To Top