SELECT * FROM V$RECOVERY_FILE_DEST; NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES -------------- ----------- ---------- ----------------- --------------- /mydisk/rcva 5368709120 109240320 256000 28 SQL> show parameter db_recovery NAME TYPE VALUE -------------------------------- ----------- ------------------------------ db_recovery_file_dest string /opt/oracle/test01/flash_recovery_area db_recovery_file_dest_size big integer 10G Command for changing db_recovery_file_dest SQL> alter system set db_recovery_file_dest='/opt/oracle/test01/dbs/arch' scope=both; System altered.