HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide
205
Free Memory—Indicate the free memory of SGA when APM did the last polling.。
Click the “threshold value setting” icon to set the warning threshold value for SGA state.
When it meets the level 1 threshold value warning condition, the yellow light displays; when it
meets the level 2 threshold value warning condition, the red light displays. You can use the
custom threshold or global threshold to set the threshold value. Pay more attention that the
higher the hit ratio index is, the performance is better, so the threshold condition ought to be
set to “Less than or equal to.”
History Record—Click the History Record icon to view the SGA state related index trend
in a past time period, which includes the last 1 hour, last 6 hours, today, yesterday, this week,
this month, and this year. If you select the time period Last 1 hour, Last 6 hours, or
Today, the SGA state related index of the Oracle is measured in unit of a polling interval; if
you select the time period Yesterday, This week, or This month, the SGA state of the
Oracle is measured in hours, and the diagram displays the SGA state related index trend,
and the maximum, minimize, and average SGA state of the Oracle; if you select the time
period This year, the SGA state of the Oracle is measured in days, and the diagram
displays the SGA state trend, and the maximum, minimize, and average SGA state of the
Oracle. Move the pointer over the each sampling point to view the SGA state of the Oracle for
the time being.
SGA details
This SGA Details are shown in Figure 153.
Figure 153 SGA details-Oracle
• Fresh—click the fresh icon to update the detail.
• Attribute and Value—Indicate the name and date of the monitor indexes. The indexes include:
Buffer—Indicate the size of buffered cache in the SGA space when APM did the last polling.
Fixed Area—Indicate the fixed size in the SGA space when APM did the last polling.
REDO Log Area—Indicate the size of redo log in the SGA space when APM did the last
polling.
Shared Pool—Indicate the size of shared pool in the SGA space when APM did the last
polling.