Monitoring Space in the Flash Recovery Area

Previous

Next

---

You must run a SQL query to determine the current available space in the flash recovery area.

To view current available space in the flash recovery area:

1. Access the Database Home page, and log in as user SYSTEM, providing the password that you set upon installation (Windows) or configuration (Linux).

   See "Accessing the Database Home Page" for instructions.

2. Click the SQL icon, and then click the SQL Commands icon.

   The SQL Commands page appears.

3. Enter the following query into the query text field:

   SELECT 
       NAME, 
       TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
       TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
          AS SPACE_AVAILABLE,
       ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
          AS PERCENT_FULL
       FROM V$RECOVERY_FILE_DEST;
   
   

4. Click Run to run the query.

Query results should look something like this:

-------------------------------------------------------------------------------------------------
NAME                                                SPACE_LIMIT    SPACE_AVAILABLE   PERCENT_FULL
/usr/lib/oracle/xe/app/oracle/flash_recovery_area  10,737,418,240   10,737,418,240      5.1
------------------------------------------------------------------------------------------------- 

Interpret the results as follows:

• NAME indicates the current flash recovery area location.

• SPACE_LIMIT indicates the current flash recovery area maximum size.

• SPACE_AVAILABLE indicates the space available for storing new backups and archived redo logs, including space that can be reclaimed by deleting files that are no longer needed to meet the retention policy.

• PERCENT_FULL indicates the current percentage of flash recovery area space used for backups and archived redo logs that are within the backup retention policy.

  
  

  Note: If the PERCENT_FULL value is frequently close to 100% after several recent backups, consider allocating more space for your flash recovery area as described in "Setting Flash Recovery Area Location and Size", or, if in ARCHIVELOG mode, taking backups more frequently to reduce the size of the retained archived log files.