isitdevops.com/databases

select * from v$flash_recovery_area_usage;

show parameter flash
show parameter db_recovery

select flashback_on from v$database;

 

select (100-sum(percent_space_used)) SPACE_REMAINING_PERCENTAGE from v$flash_recovery_area_usage;

 

select ((p.value/(1048576*1024))*f.space_USED_percentage) GB_USED
from
(select (sum(percent_space_used)/100) SPACE_USED_PERCENTAGE from v$flash_recovery_area_usage) f,
v$parameter p
where p.name=’db_recovery_file_dest_size’;

select ((p.value/(1048576*1024))*f.space_remaining_percentage) GB_REMAINING
from
(select 1-(sum((percent_space_used))/100) SPACE_REMAINING_PERCENTAGE from v$flash_recovery_area_usage) f,
v$parameter p
where p.name=’db_recovery_file_dest_size’;

select ((p.value/(1048576*1024))*f.space_reclaimable_percentage) GB_RECLAIMABLE
from
(select (sum((percent_space_reclaimable))/100) SPACE_RECLAIMABLE_PERCENTAGE from v$flash_recovery_area_usage) f,
v$parameter p
where p.name=’db_recovery_file_dest_size’;

 

select  oldest_flashback_scn scn
,       to_char(oldest_flashback_time, ‘hh24:mi:ss dd/mm/yyyy’) oldest_time
from    v$flashback_database_log
/

exit