Thursday, September 01, 2005

What Kind of Options Are Used With DBCA?

Yesterday someone asked me whether the default DBCA-created database would end up with a Flash Recovery Area defined, and where would it be?
I went poking around and found the default DBCA template here:
$ORACLE_HOME/assistants/dbca/templates/New_Database.dbt
A look in there for the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_SIZE parameters shows that they are set to $ORACLE_BASE/flash_recovery_area and 2GB, respectively.
So if you ever wonder what options DBCA is using, that's where to look.