Oracle Tips by Burleson

Oracle 10g RMAN New Recovery Area Dictionary View

Oracle 10g has a new dynamic performance view for monitoring the recovery area:

SQL> desc v$recovery_file_dest                               
 Name                      Null?    Type     
 ------------------------- -------- -----------
 NAME                               VARCHAR2(513)
 SPACE_LIMIT                        NUMBER
 SPACE_USED                         NUMBER
 SPACE_RECLAIMABLE                  NUMBER
 NUMBER_OF_FILES                    NUMBER

Column Description:

• NAME: Recovery area name, indicating location string.
   

• SPACE_LIMIT: used space by recovery area files in bytes
   

• SPACE_RECLAIMABILE: amount of space that can be created by deleting obsolete, redundant, and other low priority files through the space management algorithm.
   

• NUMBER_OF_FILE: number of files

Example:

SQL> select * from v$recovery_file_dest;

NAME          SPACE_LIMIT   SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------    -----------   ---------- ---------------- ----------------
/dba/backup   2147483648     458219520                0               49

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm