Parameter für Oracle Database 10g

Folgende Parameter sind für Datenbanken der Version Oracle 10g Release 2 eintellbar:

Parameter-Name Beschreibung
O7_DICTIONARY_ACCESSIBILITY Version 7 Dictionary Accessibility Support
active_instance_count number of active instances in the cluster database
aq_tm_processes number of AQ Time Managers to start
archive_lag_target Maximum number of seconds of redos the standby could lose
asm_diskgroups disk groups to mount automatically
asm_diskstring disk set locations for discovery
asm_power_limit number of processes for disk rebalancing
audit_file_dest Directory in which auditing files are to reside
audit_sys_operations enable sys auditing
audit_syslog_level Syslog facility and level
audit_trail enable system auditing
background_core_dump Core Size for Background Processes
background_dump_dest Detached process dump directory
backup_tape_io_slaves BACKUP Tape I/O slaves
bitmap_merge_area_size maximum memory allow for BITMAP MERGE
blank_trimming blank trimming semantics parameter
buffer_pool_keep Number of database blocks/latches in keep buffer pool
buffer_pool_recycle Number of database blocks/latches in recycle buffer pool
circuits max number of circuits
cluster_database if TRUE startup in cluster database mode
cluster_database_instances number of instances to use for sizing cluster db SGA structures
cluster_interconnects interconnects for RAC use
commit_point_strength Bias this node has toward not preparing in a two-phase commit
commit_write transaction commit log write behaviour
compatible Database will be completely compatible with this software version
control_file_record_keep_time control file record keep time in days
control_files control file names list
core_dump_dest Core dump directory
cpu_count number of CPUs for this instance
create_bitmap_area_size size of create bitmap buffer for bitmap index
create_stored_outlines create stored outlines for DML statements
cursor_sharing cursor sharing mode
cursor_space_for_time use more memory in order to get faster execution
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_block_buffers Number of database blocks cached in memory
db_block_checking header checking and data and index block checking
db_block_checksum store checksum in db blocks and check during reads
db_block_size Size of database block in bytes
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_domain directory part of global database name stored with CREATE DATABASE
db_file_multiblock_read_count db block to be read each IO
db_file_name_convert datafile name convert patterns and strings for standby/clone db
db_files max allowable # db files
db_flashback_retention_target Maximum Flashback Database log retention time in minutes.
db_keep_cache_size Size of KEEP buffer pool for standard block size buffers
db_name database name specified in CREATE DATABASE
db_recovery_file_dest default database recovery file location
db_recovery_file_dest_size database recovery files size limit
db_recycle_cache_size Size of RECYCLE buffer pool for standard block size buffers
db_unique_name Database Unique Name
db_writer_processes number of background database writer processes to start
dbwr_io_slaves DBWR I/O slaves
ddl_wait_for_locks Disable NOWAIT DML lock acquisitions
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)
disk_asynch_io Use asynch I/O for random access devices
dispatchers specifications of dispatchers
distributed_lock_timeout number of seconds a distributed transaction waits for a lock
dml_locks dml locks - one for each table modified in a transaction
drs_start start DG Broker monitor (DMON process)
event debug event control - default null string
fal_client FAL client
fal_server FAL server list
fast_start_io_target Upper bound on recovery reads
fast_start_mttr_target MTTR target in seconds
fast_start_parallel_rollback max number of parallel recovery slaves that may be used
file_mapping enable file mapping
fileio_network_adapters Network Adapters for File I/O
filesystemio_options IO operations on filesystem files
fixed_date fixed SYSDATE value
gc_files_to_locks mapping between file numbers and global cache locks
gcs_server_processes number of background gcs server processes to start
global_context_pool_size Global Application Context Pool Size in Bytes
global_names enforce that database links have same name as remote database
hash_area_size size of in-memory hash work area
hi_shared_memory_address SGA starting address (high order 32-bits on 64-bit platforms)
hs_autoregister enable automatic server DD updates in HS agent self-registration
ifile include file in init.ora
instance_groups list of instance group names
instance_name instance name supported by the instance
instance_number instance number
instance_type type of instance to be executed
java_max_sessionspace_size max allowed size in bytes of a Java sessionspace
java_pool_size size in bytes of java pool
java_soft_sessionspace_limit warning limit on size in bytes of a Java sessionspace
job_queue_processes number of job queue slave processes
large_pool_size size in bytes of large pool
ldap_directory_access RDBMS's LDAP access option
license_max_sessions maximum number of non-system user sessions allowed
license_max_users maximum number of named users that can be created in the database
license_sessions_warning warning level for number of non-system user sessions
local_listener local listener
lock_name_space lock name space used for generating lock names for standby/clone database
lock_sga Lock entire SGA in physical memory
log_archive_config log archive config parameter
log_archive_dest archival destination text string
log_archive_dest_1 archival destination #1 text string
log_archive_dest_10 archival destination #10 text string
log_archive_dest_2 archival destination #2 text string
log_archive_dest_3 archival destination #3 text string
log_archive_dest_4 archival destination #4 text string
log_archive_dest_5 archival destination #5 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_1 archival destination #1 state text string
log_archive_dest_state_10 archival destination #10 state text string
log_archive_dest_state_2 archival destination #2 state text string
log_archive_dest_state_3 archival destination #3 state text string
log_archive_dest_state_4 archival destination #4 state text string
log_archive_dest_state_5 archival destination #5 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
log_archive_duplex_dest duplex archival destination text string
log_archive_format archival destination format
log_archive_local_first Establish EXPEDITE attribute default value
log_archive_max_processes maximum number of active ARCH processes
log_archive_min_succeed_dest minimum number of archive destinations that must succeed
log_archive_start start archival process on SGA initialization
log_archive_trace Establish archivelog operation tracing level
log_buffer redo circular buffer size
log_checkpoint_interval # redo blocks checkpoint threshold
log_checkpoint_timeout Maximum time interval between checkpoints in seconds
log_checkpoints_to_alert log checkpoint begin/end to alert file
log_file_name_convert logfile name convert patterns and strings for standby/clone db
logmnr_max_persistent_sessions maximum number of threads to mine
max_commit_propagation_delay Max age of new snapshot in .01 seconds
max_dispatchers max number of dispatchers
max_dump_file_size Maximum size (blocks) of dump file
max_enabled_roles max number of roles a user can have enabled
max_shared_servers max number of shared servers
nls_calendar NLS calendar system name
nls_comp NLS comparison
nls_currency NLS local currency symbol
nls_date_format NLS Oracle date format
nls_date_language NLS date language name
nls_dual_currency Dual currency symbol
nls_iso_currency NLS ISO currency territory name
nls_language NLS language name
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
nls_numeric_characters NLS numeric characters
nls_sort NLS linguistic definition name
nls_territory NLS territory name
nls_time_format time format
nls_time_tz_format time with timezone format
nls_timestamp_format time stamp format
nls_timestamp_tz_format timestampe with timezone format
object_cache_max_size_percent percentage of maximum size over optimal of the user session's object cache
object_cache_optimal_size optimal size of the user session's object cache in bytes
olap_page_pool_size size of the olap page pool in bytes
open_cursors max # cursors per session
open_links max # open links per session
open_links_per_instance max # open links per instance
optimizer_dynamic_sampling optimizer dynamic sampling
optimizer_features_enable optimizer plan compatibility parameter
optimizer_index_caching optimizer percent index caching
optimizer_index_cost_adj optimizer index cost adjustment
optimizer_mode optimizer mode
optimizer_secure_view_merging optimizer secure view merging and predicate pushdown/movearound
os_authent_prefix prefix for auto-logon accounts
os_roles retrieve roles from the operating system
parallel_adaptive_multi_user enable adaptive setting of degree for multiple user streams
parallel_automatic_tuning enable intelligent defaults for parallel execution parameters
parallel_execution_message_size message buffer size for parallel execution
parallel_instance_group instance group to use for all parallel operations
parallel_max_servers maximum parallel query servers per instance
parallel_min_percent minimum percent of threads required for parallel query
parallel_min_servers minimum parallel query servers per instance
parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OPS SGA structures
parallel_threads_per_cpu number of parallel execution threads per CPU
pga_aggregate_target Target size for the aggregate PGA memory consumed by the instance
plsql_ccflags PL/SQL ccflags
plsql_code_type PL/SQL code-type
plsql_compiler_flags PL/SQL compiler flags
plsql_debug PL/SQL debug
plsql_native_library_dir plsql native library dir
plsql_native_library_subdir_count plsql native library number of subdirectories
plsql_optimize_level PL/SQL optimize level
plsql_v2_compatibility PL/SQL version 2.x compatibility flag
plsql_warnings PL/SQL compiler warnings settings
pre_11g_enable_capture To enable capture of DB Replay
pre_page_sga pre-page sga for process
processes user processes
query_rewrite_enabled allow rewrite of queries using materialized views if enabled
query_rewrite_integrity perform rewrite using materialized views with desired integrity
rdbms_server_dn RDBMS's Distinguished Name
read_only_open_delayed if TRUE delay opening of read only files until first access
recovery_parallelism number of server processes to use for parallel recovery
recyclebin recyclebin processing
remote_archive_enable remote archival enable setting
remote_dependencies_mode remote-procedure-call dependencies mode parameter
remote_listener remote listener
remote_login_passwordfile password file usage parameter
remote_os_authent allow non-secure remote clients to use auto-logon accounts
remote_os_roles allow non-secure remote clients to use os roles
replication_dependency_tracking tracking dependency for Replication parallel propagation
resource_limit master switch for resource limit
resource_manager_plan resource mgr top plan
resumable_timeout set resumable_timeout
rollback_segments undo segment list
serial_reuse reuse the frame segments
service_names service names supported by the instance
session_cached_cursors Number of cursors to cache in a session.
session_max_open_files maximum number of open files allowed per session
sessions user and system sessions
sga_max_size max total SGA size
sga_target Target size of SGA
shadow_core_dump Core Size for Shadow Processes
shared_memory_address SGA starting address (low order 32-bits on 64-bit platforms)
shared_pool_reserved_size size in bytes of reserved area of shared pool
shared_pool_size size in bytes of shared pool
shared_server_sessions max number of shared server sessions
shared_servers number of shared servers to start up
skip_unusable_indexes skip unusable indexes if set to TRUE
smtp_out_server utl_smtp server and port configuration parameter
sort_area_retained_size size of in-memory sort work area retained between fetch calls
sort_area_size size of in-memory sort work area
spfile server parameter file
sql92_security require select privilege for searched update/delete
sql_trace enable SQL trace
sql_version sql language version parameter for compatibility issues
sqltune_category Category qualifier for applying hintsets
standby_archive_dest standby database archivelog destination text string
standby_file_management if auto then files are created/dropped automatically on standby
star_transformation_enabled enable the use of star transformation
statistics_level statistics level
streams_pool_size size in bytes of the streams pool
tape_asynch_io Use asynch I/O requests for tape devices
thread Redo thread to mount
timed_os_statistics internal os statistic gathering interval in seconds
timed_statistics maintain internal timing statistics
trace_enabled enable KST tracing
tracefile_identifier trace file custom identifier
transactions max. number of concurrent active transactions
transactions_per_rollback_segment number of active transactions per rollback segment
undo_management instance runs in SMU mode if TRUE, else in RBU mode
undo_retention undo retention in seconds
undo_tablespace use/switch undo tablespace
use_indirect_data_buffers Enable indirect data buffers (very large SGA on 32-bit platforms)
user_dump_dest User process dump directory
utl_file_dir utl_file accessible directories list
workarea_size_policy policy used to size SQL working areas (MANUAL/AUTO)