SELECT name, (space_limit/1024/1024) ||'MB' AS Space_Limit, (space_used/1024/1024)||'MB' AS Space_Used FROM v$recovery_file_dest;