1.2 Basic Initialization Parameters

Most databases should only need to have the database basic initialization parameters set to run properly and efficiently.

Oracle advises you to become familiar with the basic parameters and only use other parameters when directed to by feature documentation or in special circumstances. The following is a list of the database basic initialization parameters:

• CLUSTER_DATABASE
• COMPATIBLE
• CONTROL_FILES
• DB_BLOCK_SIZE
• DB_CREATE_FILE_DEST
• DB_CREATE_ONLINE_LOG_DEST_n
• DB_DOMAIN
• DB_NAME
• DB_RECOVERY_FILE_DEST
• DB_RECOVERY_FILE_DEST_SIZE
• DB_UNIQUE_NAME
• INSTANCE_NUMBER
• LDAP_DIRECTORY_SYSAUTH
• LOG_ARCHIVE_DEST_n
• LOG_ARCHIVE_DEST_STATE_n
• NLS_DATE_LANGUAGE
• NLS_TERRITORY
• OPEN_CURSORS
• PGA_AGGREGATE_TARGET
• PROCESSES
• REMOTE_LISTENER
• REMOTE_LOGIN_PASSWORDFILE
• SESSIONS
• SGA_TARGET
• SHARED_SERVERS
• STAR_TRANSFORMATION_ENABLED
• UNDO_TABLESPACE