Oracle Database Administration: The Essential Refe

Name

ALTER SYSTEM

Synopsis

ALTER SYSTEM
   [SET
     {
      [ALLOW_PARTIAL_SN_RESULTS = {TRUE | FALSE} ]
[BACKUP_DISK_IO_SLAVES = integer DEFERRED]
[BACKUP_TAPE_IO_SLAVES = integer DEFERRED]
      [CACHE_INSTANCES = integer]
[CONTROL_FILE_RECORD_KEEP_TIME = integer
DEFERRED]
      [DB_BLOCK_CHECKPOINT_BATCH = integer]
      [DB_BLOCK_CHECKSUM = {TRUE | FALSE} ]
      [DB_BLOCK_MAX_DIRTY_TARGET = integer]
[DB_FILE_MULTIBLOCK_READ_COUNT = integer]
      [FIXED_DATE = {'DD_MM_YY’ | ‘YYYY_MM_DD_HH24_MI_SS'} ]
[FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY = {TRUE | FALSE } DEFERRED]
      [GC_DEFER_TIME = integer]
      [GLOBAL_NAMES = {TRUE | FALSE} ]
      [HASH_MULTIBLOCK_IO_COUNT = integer]
      [JOB_QUEUE_PROCESSES = integer]
      [LICENSE_MAX_SESSIONS = integer]
      [LICENSE_MAX_USERS = integer]
      [LICENSE_SESSIONS_WARNING = integer]
      [LOG_ARCHIVE_DUPLEX_DEST = 'text' ]
[LOG_ARCHIVE_MIN_SUCCEED_DEST = integer]
      [LOG_CHECKPOINT_INTERVAL = integer]
      [LOG_CHECKPOINT_TIMEOUT = integer]
      [LOG_SMALL_ENTRY_MAX_SIZE = integer]
[MAX_DUMP_FILE_SIZE = {size | UNLIMITED}]
[MTS_DISPATCHERS = 'protocol,
integer']
      [MTS_SERVERS = integer]
      [RESOURCE_LIMIT   {TRUE | FALSE} ]
[OBJECT_CACHE_MAX_SIZE_PERCENT = integer]
      [OBJECT_CACHE_OPTIMAL_SIZE = integer]
      [OPS_ADMIN_GROUP = 'text' ]
      [PARALLEL_INSTANCE_GROUP = 'text' ]
[PARALLEL_TRANSACTION_RESOURCE_TIMEOUT =
integer]
      [PLSQL_V2_COMPATIBILITY = {TRUE | FALSE} ]
      [REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE} ]
      [RESOURCE_LIMIT = {TRUE | FALSE} ]
      [SCAN_INSTANCES = integer]
      [SORT_AREA_SIZE = integer]
      [SORT_AREA_RETAINED_SIZE = integer