Settings and Parameters Flashcards
FRA Defaults
Location: $ORACLE_BASE/fast_recovery_area
Size: 2,048mb
DB_BLOCK_SIZE
Defaults to 8kb
Can’t modify after DB creation
Options: 2kb, 4kb, 8kb, 16kb, 32kb
CLUSTER_DATABASE
Requires bounce
Tells instance whether it’s part of a cluster DB
COMPATIBLE
Requires bounce
Release level and feature set to be active in this instance.
CONTROL_FILES
Requires bounce
Designates physical location of ctl files.
DB_CREATE_FILE_DEST
Dynamic
Specifies location for data files if using Managed Files feature.
DB_CREATE_ONLINE_LOG_DEST_n
Dynamic Specifies location(s) for redo log files if using Managed Files feature.
DB_DOMAIN
Requires bounce
Logical location of DB on network
DB_NAME
Requires Bounce
Name of DB mounted by this instance
DB_RECOVERY_FILE_DEST
Dynamic
Location for recovery files if using flash recovery.
DB_RECOVERY_FILE_DEST_SIZE
Dynamic
Amount of disk space available for recovery files.
DB_UNIQUE_NAME
Requires bounce
Specifies unique name for DB within enterprise.
INSTANCE_NUMBER
Requires Bounce
Identifies instance if in a RAC environment.
LDAP_DIRECTORY_SYSAUTH
Requires bounce
Enables or disables LDAP for SYSDBA and SYSOPER connections.
LOG_ARCHIVE_DEST_n
Dynamic
Specifies up to 9 locations for redo log file archives.
LOG_ARCHIVE_DEST_STATE_n
Dynamic
Indicates how the specified locations should be used for archiving log files.
NLS_LANGUAGE
Requires bounce
Specifies default language of DB
NLS_TERRITORY
Requires bounce
Specifies default region or territory of DB.