10g shared flash recovery area size

From: <haiwu.us_at_gmail.com>
Date: 26 Oct 2005 16:38:48 -0700
Message-ID: <1130369928.599390.287570@f14g2000cwb.googlegroups.com>

We have 2 database instances running on the same Oracle 10g RAC, say their database names are 'db1' and 'db2'. For 'db1': db_recovery_file_dest_size=10G; db_recovery_file_dest='/oracle/flash_recovery_area'; For 'db2': db_recovery_file_dest_size=10G; db_recovery_file_dest='/oracle/flash_recovery_area';

Both 'db1' and 'db2' are sharing the same folder ('/oracle/flash_recovery_area') as their flash_recovery_area. Oracle will auto-create 2 folders under the recovery area folder:
'/oracle/flash_recovery_area/DB1' and
'/oracle/flash_recovery_area/DB2'.

My question is:
How does Oracle determine the flash recovery area size? Would it caculate the max size for contents under '/oracle/flash_recovery_area' as 20GB? Or is it still just 10GB?

Thanks, Received on Wed Oct 26 2005 - 18:38:48 CDT