HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide

205
Free MemoryIndicate the free memory of SGA when APM did the last polling.
Click the threshold value settingicon 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
Freshclick the fresh icon to update the detail.
Attribute and ValueIndicate the name and date of the monitor indexes. The indexes include:
BufferIndicate the size of buffered cache in the SGA space when APM did the last polling.
Fixed AreaIndicate the fixed size in the SGA space when APM did the last polling.
REDO Log AreaIndicate the size of redo log in the SGA space when APM did the last
polling.
Shared PoolIndicate the size of shared pool in the SGA space when APM did the last
polling.