HP Intelligent Management Center v5.1 SP1 Application Manager Administrator Guide
206
Database Buffer—Indicate the size of library cache in the SGA space when APM did the last
polling.
Dictionary Buffer—Indicate the size of library cache in the SGA space when APM did the last
polling.
SQL Area—Indicate the size of SQL Area in the SGA space when APM did the last polling.
History Record—Click the History Record icon to view the SGA detail 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 detail 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 detail of the
Oracle is measured in hours, and the diagram displays the SGA detail related index trend,
and the maximum, minimize, and average SGA detail of the Oracle; if you select the time
period This year, the SGA detail of the Oracle is measured in days, and the diagram
displays the SGA detail trend, and the maximum, minimize, and average SGA detail of the
Oracle. Move the pointer over the each sampling point to view the SGA detail of the Oracle
for the time being.
Rollback
Rollback is shown in Figure 154.
Figure 154 Rollback-Oracle
• Fresh—Click the Fresh icon to update the detail.
• Segment—Indicate the name of the rollback segment.
• Table space—Indicate the name of the table space.
• Status—Indicate the status of rollback segment, include: ONLINE,PENDING OFFLINE and
OFFLINE.
ONLINE—Indicate the status of segment is ONLINE.
PENDING OFFLINE—Indicate the status of segment is offline but there are still some activities
using the rollback segment.
OFFLINE—Indicate the status of PENDING OFFLINE segment when the activities are finished.
• Current Size—Indicate the size of the rollback segment.
• Current Blocks—Indicate the number of the current blocks used by rollback segment.
• Initial Extent Segment—Indicate the size of the first extent segment distribute for rollback segment.
• Next Extent Segment—Indicate the size the second extent segment distribute for rollback segment.
• Min Extent Segment—Indicate the number of the minimum extent segment distribute for rollback
segment.