Oracle initializatoin parameters

Note: Oracle 11g R1

PARAMETER NAME	DESCRIPTION
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
asm_preferred_read_failure_groups	preferred read failure groups
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 Oracle parameter audit_trail and "alter database open read only" Notes on Auditing in Oracle Database
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
client_result_cache_lag	client result cache maximum lag in milliseconds
client_result_cache_size	client result cache max size in bytes
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_logging	transaction commit log write behaviour
commit_point_strength	Bias this node has toward not preparing in a two-phase commit
commit_wait	transaction commit log wait behaviour
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
control_management_pack_access	declares which manageability packs are enabled
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_lost_write_protect	enable lost write detection
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_securefile	permit securefile storage during lob creation
db_ultra_safe	Sets defaults for other parameters that control protection levels
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_lock_timeout	timeout to restrict the time that ddls wait for dml lock
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)
diagnostic_dest	diagnostic base directory
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)
enable_ddl_logging	enable ddl logging
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
global_txn_processes	number of background global transaction processes to start
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_jit_enabled	Java VM JIT enabled
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	maximum number of job queue slave processes
large_pool_size	size in bytes of large pool
ldap_directory_access	RDBMS's LDAP access option
ldap_directory_sysauth	OID usage parameter
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
max_commit_propagation_delay	Max age of new snapshot in .01 seconds
max_dispatchers	max number of dispatchers
max_dump_file_size	Maximum size (in bytes) of dump file
max_enabled_roles	max number of roles a user can have enabled
max_shared_servers	max number of shared servers
memory_max_target	Max size for Memory Target
memory_target	Target size of Oracle SGA and PGA memory
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_capture_sql_plan_baselines	automatic capture of SQL plan baselines for repeatable statements
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
optimizer_use_invisible_indexes	Usage of invisible indexes (TRUE/FALSE)
optimizer_use_pending_statistics	Control whether to use optimizer pending statistics
optimizer_use_sql_plan_baselines	use of SQL plan baselines for captured sql statements
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_io_cap_enabled	enable capping DOP by IO bandwidth
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
plscope_settings	plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
plsql_ccflags	PL/SQL ccflags
plsql_code_type	PL/SQL code-type
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_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
redo_transport_user	Data Guard transport user when using password file
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_cpu_allocation	Resource Manager CPU allocation
resource_manager_plan	resource mgr top plan
result_cache_max_result	maximum result size as percent of cache size
result_cache_max_size	maximum amount of memory to be used by the cache
result_cache_mode	result cache operator usage mode
result_cache_remote_expiration	maximum life time (min) for any result using a remote object
resumable_timeout	set resumable_timeout
rollback_segments	undo segment list
sec_case_sensitive_logon	case sensitive password enabled for logon
sec_max_failed_login_attempts	maximum number of failed login attempts on a connection
sec_protocol_error_further_action	TTC protocol error continue action
sec_protocol_error_trace_action	TTC protocol error action
sec_return_server_release_banner	whether the server retruns the complete version information
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 STATISTICS_LEVEL and V$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 in memory 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)
xml_db_events	are XML DB events enabled