companyname.com)
LOG_ARCHIVE_DEST
The log archive destination
LOG_ARCHIVE_DEST_STATE
The parameter that enables log archiving
DB_RECOVERY_FILE_DEST
The location of the database flash recovery area (directory, filesystem, or ASM
disk group)
DB_RECOVERY_FILE_DEST_SIZE
The database flash recovery area maximum size in total bytes
DB_BLOCK_SIZE
The database block size in bytes (e.g., 4 KB = 4,096)
38 | Chapter 2: Oracle Architecture
PROCESSES
The maximum number of concurrent database operating system processes
SESSIONS
The maximum number of database sessions
OPEN_CURSORS
The maximum number of database open cursors
SHARED_SERVERS
The minimum number of database shared servers
REMOTE_LISTENER
The remote listener name
COMPATIBLE
The database version youwant for compatibility where features affect file format
(e.g., 11.1.0, 10.0.0)
MEMORY_TARGET
The target memory size that is automatically allocated to SGA and instance PGA
components
DDL_LOCK_TIMEOUT
For data definition language (DDL) statements, the time a DDL statement waits
for an exclusive lock (in seconds) before failing
NLS_LANGUAGE
The National Language Support (NLS) language specified for the database
NLS_TERRITORY
The National Language Support territory specified for the database
As an example in the shift toward automation, in Oracle Database 11g, the UNDO_
MANAGEMENT parameter default is now set to automatic undo management.
Pages:
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112