Spotlight on Oracle 10.8 - Getting Started Guide

The Disk Storage panel represents Oracle database and log files on disk:

Tip: Right-click the Disk Storage icon to open Space Manager. Tools | Space Manager

Database Files

Oracle database files. The level of fill in this component corresponds to the overall space utilization in the database.

The Excessive RBS Activities Alarm may occur if the RBS (rollback segments) activity exceeds a threshold.

Notes:

• There may be a discrepancy between the number of tablespaces, database size, and the database percentage used reported in the Disk Storage Panel and the corresponding statistics reported in the TableSpace Utilization page.

  This is because the statistics on the home page EXCLUDE locally managed temporary tablespaces and objects in the recycle bin.

• (Oracle 11g Release 2 and later) Used and free calculations take into account space that is in the recycle bin that can be reclaimed if space is lacking.

Flash Cache

The size of the flash cache.

Flash cache applies only to (Oracle 11g Release 2) databases running on Solaris or Linux. The Flash Cache configuration parameter DB_FLASH_CACHE_FILE must be enabled and DB_FLASH_CACHE_SIZE must be set to greater than 0 to see flash cache data on the home page and in the drilldown. If these parameters are not enabled, the Flash Cache statistic on the Spotlight home page displays "N/A" and the drilldown is unavailable.

The following alarms may be raised here:

• Flash Cache Insert Skip: DBWR Overloaded Alarm
• Flash Cache Read Latency Alarm
• Flash Cache Write Complete Waits Alarm

Note: The Flash Cache statistic on the home page displays "N/A" if:

• You are connected to a version of Oracle (Oracle 11g Release 1 and earlier).
• You are connected to (Oracle 11g Release 2) but the flash cache configuration parameters are not enabled. See above for more information.

Flashback Recovery

This control shows the size of the flash recovery area (flashback area) and the amount of the area that is in use.

A flashback area that is full is not desirable, but it may not be a cause for alarm unless none of the files in the area are reclaimable — see the Disk Storage | Recovery Area Page for more details.

Alarms that may be raised here include:

• Flashback Space Usage Alarm
• Insufficient Flashback Logs Alarm
• Non-reclaimable Flashback Space Alarm

Note: Values in the flashback container, and in the Size and Used fields, may not be available for (Oracle 10g Release 1 and earlier).

Redo Logs

Oracle redo logs. The fill level of the component corresponds to the number of archive logs that have not yet been archived (if archiving is enabled).

The Unarchived Logs Alarm occurs if the number of unarchived redo logs exceeds a threshold.

Archive Log

Details of the archive log destination(s) for redo log files. Archiving Oracle redo logs is important for safeguarding database changes and for recovery.

The information in this panel shows:

• The aggregate amount of space available within the archive destinations for the Oracle database.
• The total archive space for the critical archive destination.
• The free archive space in the critical archive destination.
• The time at which archiving will fail if archiving destinations are not purged or backed up to an offline medium.

Note: (Oracle 10g and later) When ASM is used for archiving, a negative value for the Free (min) metric indicates that the ASM diskgroup does not have enough space to cope with a disk failure.