CLUSTER_DATABASE - default to false - true for RAC
COMPATIBLE - guaranteeing backward compatibility - same value on both the primary and standby databases
CONTROL_FILES - names of control files - 1 to 8 filenames
DB_BLOCK_SIZE - default 8192 - 2048 to 32768 - in Bytes - size of Oracle database blocks
DB_CREATE_FILE_DEST - default location for Oracle-managed datafiles
DB_CREATE_ONLINE_LOG_DEST_n - default location for Oracle-managed control files and online redo logs
DB_DOMAIN - logical location of the database within the network structure
DB_NAME - database identifier of up to 8 characters - case insensitive
DB_RECOVERY_FILE_DEST - location for the flash recovery area - FRA contains control, redo, archive, rman, flashback logs
DB_RECOVERY_FILE_DEST_SIZE - total space to be used by target database recovery files created in FRA
DB_UNIQUE_NAME - globally unique name for the database - 30 characters and is case insensitive
INSTANCE_NUMBER - in RAC instance number 1,2...n
LDAP_DIRECTORY_SYSAUTH - directory-based authorization for SYSDBA and SYSOPER - default no
LOG_ARCHIVE_DEST_n - defines up to 10 archive log location
LOG_ARCHIVE_DEST_STATE_n - specify the availability state of the corresponding destination
NLS_LANGUAGE - default language of the database - used for messages, day and month names, symbols for AD, BC, a.m., and p.m.,
NLS_TERRITORY - territory whose conventions are to be followed for day and week numbering
OPEN_CURSORS - maximum number of open cursors a sesssion can have
PGA_AGGREGATE_TARGET - target aggregate PGA memory available to all server processes - 10 MB <> 4096 GB
PROCESSES - 6 to OS dependent - default 100
REMOTE_LISTENER - address of listeners that are not running on the same machine as this instance
REMOTE_LOGIN_PASSWORDFILE - Oracle checks for a password file - shared/exclusive/none
SESSIONS - maximum number of sessions that can be created in the system - default to (1.1 * PROCESSES) + 5 - range 1 to 2^31
SGA_TARGET - size of all SGA components(Buffer cache /Shared pool/Large pool/Java pool/Streams pool)
SHARED_SERVERS - number of server processes - 0 for not on
STAR_TRANSFORMATION_ENABLED - determines cost-based query transformation will be applied to star queries
UNDO_TABLESPACE - specifies the undo tablespace to be used when an instance starts up
COMPATIBLE - guaranteeing backward compatibility - same value on both the primary and standby databases
CONTROL_FILES - names of control files - 1 to 8 filenames
DB_BLOCK_SIZE - default 8192 - 2048 to 32768 - in Bytes - size of Oracle database blocks
DB_CREATE_FILE_DEST - default location for Oracle-managed datafiles
DB_CREATE_ONLINE_LOG_DEST_n - default location for Oracle-managed control files and online redo logs
DB_DOMAIN - logical location of the database within the network structure
DB_NAME - database identifier of up to 8 characters - case insensitive
DB_RECOVERY_FILE_DEST - location for the flash recovery area - FRA contains control, redo, archive, rman, flashback logs
DB_RECOVERY_FILE_DEST_SIZE - total space to be used by target database recovery files created in FRA
DB_UNIQUE_NAME - globally unique name for the database - 30 characters and is case insensitive
INSTANCE_NUMBER - in RAC instance number 1,2...n
LDAP_DIRECTORY_SYSAUTH - directory-based authorization for SYSDBA and SYSOPER - default no
LOG_ARCHIVE_DEST_n - defines up to 10 archive log location
LOG_ARCHIVE_DEST_STATE_n - specify the availability state of the corresponding destination
NLS_LANGUAGE - default language of the database - used for messages, day and month names, symbols for AD, BC, a.m., and p.m.,
NLS_TERRITORY - territory whose conventions are to be followed for day and week numbering
OPEN_CURSORS - maximum number of open cursors a sesssion can have
PGA_AGGREGATE_TARGET - target aggregate PGA memory available to all server processes - 10 MB <> 4096 GB
PROCESSES - 6 to OS dependent - default 100
REMOTE_LISTENER - address of listeners that are not running on the same machine as this instance
REMOTE_LOGIN_PASSWORDFILE - Oracle checks for a password file - shared/exclusive/none
SESSIONS - maximum number of sessions that can be created in the system - default to (1.1 * PROCESSES) + 5 - range 1 to 2^31
SGA_TARGET - size of all SGA components(Buffer cache /Shared pool/Large pool/Java pool/Streams pool)
SHARED_SERVERS - number of server processes - 0 for not on
STAR_TRANSFORMATION_ENABLED - determines cost-based query transformation will be applied to star queries
UNDO_TABLESPACE - specifies the undo tablespace to be used when an instance starts up
No comments:
Post a Comment