SQL ESPACIO FLASH RECOVERY AREA

SQL> select open_mode,log_mode from v$database;

OPEN_MODE      LOG_MODE

-------------------- ------------

READ WRITE      ARCHIVELOG

SQL> 

SELECT space_used/1024/1024/1024 AS "Space Used (Gb)",   space_reclaimable/1024/1024/1024 AS "Space Reclaimable (Gb)"  FROM v$recovery_file_dest
/
set lines 150
col name format a50
select * from v$instance;
show parameter control
show parameter config
show parameter db_recovery_file
select * from v$recovery_file_dest;
select * from v$flash_recovery_area_usage;
select
  round((a.space_limit / 1024 / 1024 / 1024), 2) as flash_in_gb,
  round((a.space_used / 1024 / 1024 / 1024), 2) as flash_used_in_gb,
  round((a.space_reclaimable / 1024 / 1024 / 1024), 2) as flash_reclaimable_gb,
  sum(b.percent_space_used)  as percent_of_space_used
from
  v$recovery_file_dest a,
  v$flash_recovery_area_usage b
group by
  space_limit,
  space_used ,
  space_reclaimable ;
exit