|
NAME |
VALUE |
DESCRIPTION |
|
LOG_ARCHIVE_DEST |
(PD) |
Archival destination text string |
|
LOG_ARCHIVE_DEST_1 |
NULL |
Archival destination #1 text string |
|
LOG_ARCHIVE_DEST_2 |
NULL |
Archival destination #2 text string |
|
LOG_ARCHIVE_DEST_3 |
NULL |
Archival destination #3 text string |
|
LOG_ARCHIVE_DEST_4 |
NULL |
Archival destination #4 text string |
|
LOG_ARCHIVE_DEST_5 |
NULL |
Archival destination #5 Text string |
|
LOG_ARCHIVE_DEST_STATE_1 |
enable |
Archival destination #1 state text string |
|
LOG_ARCHIVE_DEST_STATE_2 |
enable |
Archival destination #2 state text string |
|
LOG_ARCHIVE_DEST_STATE_3 |
enable |
Archival destination #3 state text string |
|
LOG_ARCHIVE_DEST_STATE_4 |
enable |
Archival destination #4 state text string |
|
LOG_ARCHIVE_DEST_STATE_5 |
enable |
Archival destination #5 state text string |
|
LOG_ARCHIVE_DUPLEX_DEST |
NULL |
Duplex archival destination text string |
|
LOG_ARCHIVE_FORMAT |
ARC%S.%T |
Archival destination Format. %s – log
sequence %t - thread number |
|
LOG_ARCHIVE_MAX_PROCESSES |
1 |
Maximum number of active ARCH processes |
|
LOG_ARCHIVE_MIN_SUCCEED_DEST |
1 |
Minimum number of archive destinations
that must succeed |
|
LOG_ARCHIVE_START |
TRUE |
Start archival process on SGA
initialization |
|
LOG_BUFFER |
500k or 128k*CPU |
Redo circular buffer size |
|
LOG_CHECKPOINT_INTERVAL |
(PD) |
# redo blocks checkpoint threshold |
|
LOG_CHECKPOINT_TIMEOUT |
0 |
Maximum time interval between checkpoints
in seconds |
|
LOG_CHECKPOINTS_TO_ALERT |
FALSE |
Log checkpoint begin/end to alert file |
|
LOG_FILE_NAME_CONVERT |
NULL |
Logfile name convert pattern and string
for standby/clone database |
|
MAX_COMMIT_PROPAGATION_DELAY |
700 |
Max age of new snapshot in .01 seconds |
|
MAX_DUMP_FILE_SIZE |
10000 |
Maximum size (blocks) of dump file |
|
MAX_ENABLED_ROLES |
20 |
Max number of roles a user can have
enabled |
|
MAX_ROLLBACK_SEGMENTS |
30 |
Max. number of rollback segments in SGA
cache |
|
MTS_DISPATCHERS |
NULL |
Specifications of dispatchers |
|
MTS_LISTENER_ADDRESS |
NULL |
Address(es) of network listener |
|
MTS_MAX_DISPATCHERS |
5 |
Max number of dispatchers |
|
MTS_MAX_SERVERS |
20 |
Max number of servers |
|
MTS_MULTIPLE_LISTENERS |
FALSE |
Are multiple listeners enabled? |
|
MTS_SERVERS |
1 |
Number of servers to start up |
|
MTS_SERVICE |
(DBD) |
Service supported by dispatchers |
|
MVIEW_REWRITE_ENABLED |
FALSE |
Allow rewrite of queries using
materialized views if enabled |
|
NLS_CALENDAR |
Gregorian |
NLS calendar system name |
|
NLS_COMP |
BINARY |
NLS comparison |
|
NLS_CURRENCY |
NULL |
NLS local currency symbol |
|
NLS_DATE_FORMAT |
NULL |
NLS Oracle date format |
|
NLS_DATE_LANGUAGE |
NULL |
NLS date language name |
|
NLS_ISO_CURRENCY |
NULL |
NLS ISO currency territory name |
|
NLS_LANGUAGE |
AMERICAN |
NLS language name |
|
NLS_NUMERIC_CHARACTERS |
NULL |
NLS numeric characters |
|
NLS_SORT |
NULL |
NLS linguistic definition name |
|
NLS_TERRITORY |
AMERICA |
NLS territory name |
|
NLS_TIME_FORMAT |
NULL |
Time format |
|
NLS_TIME_TZ_FORMAT |
NULL |
Time with timezone format |
|
NLS_TIMESTAMP_FORMAT |
NULL |
Time stamp format |
|
NLS_TIMESTAMP_TZ_FORMAT |
NULL |
Timestamp with timezone format |
|
NLS_UNION_CURRENCY |
NULL |
Union currency symbol |
|
OBJECT_CACHE_MAX_SIZE_PERCENT |
10 |
Percentage of maximum size over optimal of
the user session's object cache |
|
OBJECT_CACHE_OPTIMAL_SIZE |
102400 |
Optimal size of the user session's object
cache in bytes |
|
OPEN_CURSORS |
64 |
Max # cursors per process |
|
OPEN_LINKS |
4 |
Max # open links per session |
|
OPEN_LINKS_PER_INSTANCE |
4 |
Max # open links per instance |
|
OPTIMIZER_FEATURES_ENABLE |
8.0.0 |
Optimizer plan compatibility parameter |
|
OPTIMIZER_INDEX_CACHING |
0 |
Optimizer percent index caching |
|
OPTIMIZER_INDEX_COST_ADJ |
100 |
Optimizer index cost adjustment |
|
OPTIMIZER_MAX_PERMUTATIONS |
80000 |
Optimizer maximum join permutations per
query block |
|
OPTIMIZER_MODE |
CHOOSE |
Optimizer mode |
|
OPTIMIZER_PERCENT_PARALLEL |
100 |
Optimizer percent parallel |
|
OPTIMIZER_SEARCH_LIMIT |
5 |
Optimizer search limit |
|
ORACLE_TRACE_COLLECTION_NAME |
NULL |
Oracle TRACE default collection name |
|
ORACLE_TRACE_COLLECTION_PATH |
(PD) |
Oracle TRACE collection path |
|
ORACLE_TRACE_COLLECTION_SIZE |
5242880 |
Oracle TRACE collection file max. size |
|
ORACLE_TRACE_ENABLE |
FALSE |
Oracle TRACE instance wide enable/disable |
|
ORACLE_TRACE_FACILITY_NAME |
oracled |
Oracle TRACE default facility name |
|
ORACLE_TRACE_FACILITY_PATH |
(PD) |
Oracle TRACE facility path |
|
OS_AUTHENT_PREFIX |
OPS$ |
Prefix for auto-logon accounts |
|
OS_ROLES |
FALSE |
Retrieve roles from the operating system |
|
PARALLEL_ADAPTIVE_MULTI_USER |
FALSE |
Enable adaptive setting of degree for
multiple user streams |
|
PARALLEL_AUTOMATIC_TUNING |
FALSE |
Enable intelligent defaults for parallel
execution parameters |
|
PARALLEL_BROADCAST_ENABLED |
FALSE |
Enable broadcasting of small inputs to
hash and sort merge joins |
|
PARALLEL_EXECUTION_MESSAGE_SIZE |
4096 |
Message buffer size for parallel execution |
|
PARALLEL_INSTANCE_GROUP |
NULL |
Instance group to use for all parallel
operations |
|
PARALLEL_MAX_SERVERS |
(PD) |
Maximum parallel query servers per
instance |
|
PARALLEL_MIN_PERCENT |
0 |
Minimum percent of threads required for
parallel query |
|
PARALLEL_MIN_SERVERS |
0 |
Minimum parallel query servers per
instance |
|
PARALLEL_SERVER |
FALSE |
If TRUE startup in parallel server mode |
|
PARALLEL_SERVER_INSTANCES |
1 |
Number of instances to use for sizing OPS
SGA structures |
|
PARALLEL_THREADS_PER_CPU |
2 |
Number of parallel execution threads per
CPU |
|
PARALLEL_TRANSACTION_RECOVERY |
LOW |
Max number of parallel recovery slaves
that may be used |
|
PARTITION_VIEW_ENABLED |
FALSE |
Enable/disable partitioned views |
|
PLSQL_V2_COMPATIBILITY |
FALSE |
PL/SQL version 2.x compatibility flag |
|
PRE_PAGE_SGA |
FALSE |
Pre-page sga for process |
|
PROCESSES |
100 |
User processes |
|
READ_ONLY_OPEN_DELAYED |
FALSE |
If TRUE delay opening of read only files
until first access |
|
RECOVERY_PARALLELISM |
0 |
Number of server processes to use for
parallel recovery |
|
REMOTE_DEPENDENCIES_MODE |
TIMESTAMP |
Remote-procedure-call dependencies mode
parameter |
|
REMOTE_LOGIN_PASSWORDFILE |
NONE |
Password file usage parameter |
|
REMOTE_OS_AUTHENT |
FALSE |
allow non-secure remote clients to use
auto-logon accounts |
|
REMOTE_OS_ROLES |
FALSE
|
Allow non-secure remote clients to use os
roles |
|
REPLICATION_DEPENDENCY_TRACKING |
TRUE |
Tracking dependency for Replication
parallel propagation |
|
RESOURCE_LIMIT |
FALSE |
Master switch for resource limit |
|
RESOURCE_MANAGER_PLAN |
NULL |
Resource mgr top plan |
|
REWRITE_INTEGRITY |
enforce |
Perform rewrite using materialized views
with desired integrity |
|
ROLLBACK_SEGMENTS |
(PD) |
Private undo segment list |
|
ROW_LOCKING |
Always |
Row-locking |
|
SERIAL_REUSE |
DISABLE |
Reuse the frame segments |
|
SERIALIZABLE |
FALSE |
Serializable |
|
SERVICE_NAMES |
(DBD) |
Service names supported by the instance |
|
SESSION_CACHED_CURSORS |
0 |
Number of cursors to save in the session
cursor cache |
|
SESSION_MAX_OPEN_FILES |
10 |
Maximum number of open bfiles allowed per
session |
|
SESSIONS |
(1.1*PROC)+5 |
User and system sessions |
|
SHADOW_CORE_DUMP |
PARTIAL |
Include SGA in core dump (FULL) don't
include it (PARTIAL) |
|
SHARED_MEMORY_ADDRESS |
0 |
SGA starting address (low order 32-bits on
64-bit platforms) |
|
SHARED_POOL_RESERVED_SIZE |
5% shared pool |
Size in bytes of reserved area of shared
pool |
|
SHARED_POOL_SIZE |
<64bit 16M |
Size in bytes of shared pool |
|
SNAPSHOT_REFRESH_INTERVAL |
60 |
Wakeup interval in seconds for job queue
processes |
|
SNAPSHOT_REFRESH_KEEP_CONNECTIONS |
FALSE |
Keep network connections between execution
of refreshes |
|
SNAPSHOT_REFRESH_PROCESSES |
0 |
Number of job queue processes to start |
|
SORT_AREA_RETAINED_SIZE |
sort_area_size |
Size of in-memory sort work area retained
between fetch calls |
|
SORT_AREA_SIZE |
(PD) |
Size of in-memory sort work area |
|
SORT_MULTIBLOCK_READ_COUNT |
2 |
Multi-block read count for sorts |
|
SQL92_SECURITY |
FALSE |
Require select privilege for searched
update/delete |
|
SQL_TRACE |
FALSE |
Enable SQL trace |
|
STANDBY_ARCHIVE_DEST |
NULL |
Standby database archivelog destination
text string |
|
STAR_TRANSFORMATION_ENABLED |
FALSE |
Enable the use of star transformation |
|
TAPE_ASYNCH_IO |
TRUE |
Use asynch I/O requests for tape devices |
|
TEXT_ENABLE |
TRUE |
Enable text searching |
|
THREAD |
0 |
Redo thread to mount (OPS) |
|
TIMED_OS_STATISTICS |
0 |
Internal os statistic gathering interval
in seconds |
|
TIMED_STATISTICS |
FALSE |
Maintain internal timing statistics |
|
TRANSACTION_AUDITING |
TRUE |
Auditing transaction generated in the redo
log |
|
TRANSACTIONS |
1.1*sessions |
Max. number of concurrent active
transactions |
|
TRANSACTIONS_PER_ROLLBACK_SEGMENT |
5 |
Number of active transactions per
rollback segment |
|
USE_INDIRECT_DATA_BUFFERS |
FALSE |
Enable indirect data Buffers (very large
SGA on 32-bit platforms) |
|
USER_DUMP_DEST |
(PD) |
User process dump directory |
|
UTL_FILE_DIR |
NULL |
Utl_file accessible directories list |
The Oracle7 and Oracle8.0 initialization
parameters shown below are invalid for use with Oracle8i.
Table 12: Invalid initialization parameters
for use with Oracle8i.
