SQL Script Size Flash Recovery Area

Updated: 02-Jun-2005
Version: 1.0

Description

A script to estimate the size of the flash_recovery_area in 10G

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set ver off

ACCEPT nodays PROMPT 'Enter number of days of archive log to keep : '

var df_size number;
var ar_size number;

spool size_fra.txt

begin
  select sum(bytes) into :df_size from dba_data_files;

  select sum(blocks* block_size) into :ar_size 
  from v$archived_log
  where completion_time > sysdate - &nodays;
end;
/

REM Formula for FRA 2 copies of database + size of archive logs + 20%

print df_size
print ar_size

select (:df_size + NVL(:ar_size,0) ) * 1.2 / 1024 / 1024 "Minimum Mb" 
from dual;

select ((:df_size * 2 ) + NVL(:ar_size,0) ) * 1.2 / 1024 / 1024 "Recommended Mb" 
from dual;

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links