Prev | Current Page 662 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


The parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE are both
dynamic; they can be changed on the fly while the instance is running to respond to changes in
disk space availability.
Data Dictionary and Dynamic Performance Views
A number of Oracle data dictionary and dynamic performance views contain information specific
to RMAN operations, on both the target database and the catalog database. In Table 12-2 are
the key views related to RMAN. Each of these views will be covered in more detail later in this
chapter.
View Description
RC_* RMAN Recovery Catalog views. Only exist in the
RMAN repository database and contain recovery
information for all target databases.
V$RMAN_STATUS Displays finished and in-progress RMAN jobs.
V$RMAN_OUTPUT Contains messages generated by RMAN sessions and
each RMAN command executed within the session.
V$SESSION_LONGOPS Contains the status of long-running administrative
operations that run for more than six seconds;
includes statistics gathering and long-running
queries, in addition to RMAN recovery and
backup operations.
V$DATABASE_BLOCK_CORRUPTION Corrupted blocks detected during an RMAN session.
V$FLASH_RECOVERY_AREA_USAGE The percentage of space used, by object type, in
the flash recovery area.
V$RECOVERY_FILE_DEST The number of files, space used, space that can be
reclaimed, and space limit for the flash recovery area.
V$RMAN_CONFIGURATION RMAN configuration parameters with non-default
values for this database.


Pages:
650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674
tołpa Mateusz Grzesiak tania bieżnia magnetyczna mapic prostenal