Dynamic Database Parameters

Oracle9i New Feature Series: New Dynamic Database Parameters

Oracle9i includes several database initialization parameters that can be changed dynamically using ALTER SYSTEM or ALTER SESSION. The following are the parameters that were not modifiable in 8i, which can be modified in 9i using ALTER SYSTEM.

SHARED_POOL_SIZE

LARGE_POOL_SIZE

LOG_CHECKPOINTS_TO_ALERT

SERVICE_NAMES

LOCAL_LISTENER

OPEN_CURSORS

The following are the new parameters introduced in Oracle9i that are dynamic.

NAME

DESCRIPTION

archive_lag_target

Maximum number of seconds of redos the standby could lose

db_16k_cache_size

Size of cache for 16K buffers

db_2k_cache_size

Size of cache for 2K buffers

db_32k_cache_size

Size of cache for 32K buffers

db_4k_cache_size

Size of cache for 4K buffers

db_8k_cache_size

Size of cache for 8K buffers

db_cache_advice

Buffer cache sizing advisory

db_cache_size

Size of DEFAULT buffer pool for standard block size buffers

db_create_file_dest

default database location

db_create_online_log_dest_1

online log/controlfile destination #1

db_create_online_log_dest_2

online log/controlfile destination #2

db_create_online_log_dest_3

online log/controlfile destination #3

db_create_online_log_dest_4

online log/controlfile destination #4

db_create_online_log_dest_5

online log/controlfile destination #5

db_keep_cache_size

Size of KEEP buffer pool for standard block size buffers

db_recycle_cache_size

Size of RECYCLE buffer pool for standard block size buffers

dg_broker_config_file1

data guard broker configuration file #1

dg_broker_config_file2

data guard broker configuration file #2

dg_broker_start

start Data Guard broker framework (DMON process)

dispatchers

specifications of dispatchers

drs_start

start DG Broker monitor (DMON process)

fal_client

FAL client

fal_server

FAL server list

fast_start_mttr_target

MTTR target of forward crash recovery in seconds

file_mapping

enable file mapping

filesystemio_options

IO operations on filesystem files

log_archive_dest_10

archival destination #10 text string

log_archive_dest_6

archival destination #6 text string

log_archive_dest_7

archival destination #7 text string

log_archive_dest_8

archival destination #8 text string

log_archive_dest_9

archival destination #9 text string

log_archive_dest_state_10

archival destination #10 state text string

log_archive_dest_state_6

archival destination #6 state text string

log_archive_dest_state_7

archival destination #7 state text string

log_archive_dest_state_8

archival destination #8 state text string

log_archive_dest_state_9

archival destination #9 state text string

nls_length_semantics

create columns using byte or char semantics by default

nls_nchar_conv_excp

NLS raise an exception instead of allowing implicit conversion

olap_page_pool_size

size of the olap page pool in bytes

optimizer_dynamic_sampling

optimizer dynamic sampling

pga_aggregate_target

Target size for the aggregate PGA memory consumed by the instanc

plsql_compiler_flags

PL/SQL compiler flags

plsql_native_c_compiler

plsql native C compiler

plsql_native_library_dir

plsql native library dir

plsql_native_library_subdir_count

plsql native library number of subdirectories

plsql_native_linker

plsql native linker

plsql_native_make_file_name

plsql native compilation make file

plsql_native_make_utility

plsql native compilation make utility

remote_listener

remote listener

shared_servers

number of shared servers to start up

standby_file_management

if auto then files are created/dropped automatically on standby

statistics_level

statistics level

trace_enabled

enable KST tracing

undo_retention

undo retention in seconds

undo_suppress_errors

Suppress RBU errors in SMU mode

undo_tablespace

use/switch undo tablespace

workarea_size_policy

policy used to size SQL working areas (MANUAL/AUTO)

 

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.