Thursday 2 May 2013

TO FIND FLASH RECOVERY AREA IN ORACLE

TO FIND FLASH RECOVERY AREA IN ORACLE
select *from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area
 1.7180E+10 1.7126E+10               0          11

No comments:

Post a Comment