| 1. |
Which Views Can Be Used For Checking Space Usage In The Fra? |
|
Answer» Check Below.. SQL> SELECT NAME,SPACE_LIMIT/1024/1024/1024 TOTAL_GB,SPACE_USED/1024/1024/1024 USED_GB,SPACE_RECLAIMABLE,NUMBER_OF_FILES from v$recovery_file_dest; NAME TOTAL_GB USED_GB SPACE_RECLAIMABLE NUMBER_OF_FILES /u01/oracle/DB11G/fast_recovery_area 16 1.13197899 0 3 FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES——————– —————— ————————- ————— CONTROL FILE 0 0 0 7 rows SELECTED. Check Below.. SQL> select NAME,SPACE_LIMIT/1024/1024/1024 TOTAL_GB,SPACE_USED/1024/1024/1024 USED_GB,SPACE_RECLAIMABLE,NUMBER_OF_FILES from v$recovery_file_dest; NAME TOTAL_GB USED_GB SPACE_RECLAIMABLE NUMBER_OF_FILES /u01/oracle/DB11G/fast_recovery_area 16 1.13197899 0 3 FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES——————– —————— ————————- ————— CONTROL FILE 0 0 0 7 rows selected. |
|