Hello all,
could you give an advice about "issue" I have with Oracle database server 10.2.0.5 on linux machine.
SYS@test10u AS SYSDBA> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
SYS@test10u AS SYSDBA> select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
2 3 4 5 6 /
NAME
--------------------------------------------------------------------------------
Size MB Used MB
---------- ----------
/mnt/autofs/s28backup/flash_recovery_area
25600 0
SYS@test10u AS SYSDBA> sho parameter RECOVERY_FILE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /mnt/autofs/s28backup/flash_re
covery_area
db_recovery_file_dest_size big integer 25G
I was thinking that it could be