[code language=”sql”]

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.
[/code]