15-SEP-2007 14:11:21 TESTDB1

All INIT.ORA Parameters
Parameter (1) Desc Value Default
_affinity_on enable/disable affinity at run time TRUE TRUE
_allow_resetlogs_corruption allow resetlogs even if it will cause corruption FALSE TRUE
_bump_highwater_mark_count how many blocks should we allocate per free list on advancing HW 0 TRUE
_controlfile_enqueue_timeout control file enqueue timeout in seconds 900 TRUE
_corrupt_blocks_on_stuck_recovery number of times to corrupt a block when media recovery stuck 0 TRUE
_corrupted_rollback_segments corrupted undo segment list   TRUE
_cr_deadtime global cache lock CR deadlock timeout in seconds 6 TRUE
_db_block_cache_clone Always clone data blocks on get (for debugging) FALSE TRUE
_db_block_cache_protect protect database blocks (true only when debugging) FALSE TRUE
_db_block_hash_buckets Number of database block hash buckets 250 FALSE
_db_block_max_cr_dba Maximum Allowed Number of CR buffers per dba 10 TRUE
_db_block_max_scan_cnt Maximum number of buffers to inspect when looking for free 10000 FALSE
_db_block_multiple_hashchain_latches Use one latch per hash chain (vs one latch for all changes) TRUE TRUE
_db_block_no_idle_writes Disable periodic writes of buffers when idle FALSE TRUE
_db_block_write_batch Number of blocks to group in each DB Writer IO 512 FALSE
_db_handles System-wide simultaneous buffer operations 2100 FALSE
_db_handles_cached Buffer handles cached each process 3 TRUE
_db_large_dirty_queue Number of buffers which force dirty queue to be written 0 TRUE
_db_no_mount_lock do not get a mount lock FALSE TRUE
_db_writer_scan_depth Number of LRU buffers for dbwr to scan when looking for dirty 0 TRUE
_db_writer_scan_depth_decrement Subtract from dbwr scan depth when dbwr is working too hard 0 TRUE
_db_writer_scan_depth_increment Add to dbwr scan depth when dbwr is behind 0 TRUE
_dbwr_slave_batch_size DBWR slave I/O batch size 1 TRUE
_debug_sga debug sga FALSE TRUE
_disable_blocking_waiters Don't allow waiters to block PCM lock release FALSE TRUE
_disable_logging Disable logging FALSE TRUE
_disable_oracle_resilvering disable oracle resilvering for fast instance recovery FALSE TRUE
_enable_dba_locking enable persistent locking FALSE TRUE
_enqueue_debug_multi_instance debug enqueue multi instance FALSE TRUE
_enqueue_hash enqueue hash table length 1145 FALSE
_enqueue_hash_chain_latches enqueue hash chain latches 4 FALSE
_enqueue_locks locks for managed enqueues 6754 FALSE
_gc_recovery_scan_smon if TRUE, do recovery scans in SMON stead of LCK processes FALSE TRUE
_init_sql_file File containing SQL statements to execute upon database creation ?/dbs/sql.bsq TRUE
_kgl_bucket_count index to the bucket count array 0 TRUE
_kgl_latch_count number of library cache latches 0 TRUE
_kgl_multi_instance_invalidation whether KGL to support multi-instance invalidations TRUE TRUE
_kgl_multi_instance_lock whether KGL to support multi-instance locks TRUE TRUE
_kgl_multi_instance_pin whether KGL to support multi-instance pins TRUE TRUE
_latch_recovery_alignment align latch recovery structures 60 TRUE
_latch_spin_count amount to spin waiting for a latch 100 TRUE
_latch_wait_posting post sleeping processes when free latch 1 TRUE
_log_blocks_during_backup log block images when changed during backup TRUE TRUE
_log_buffers_debug debug redo buffers (slows things down) FALSE TRUE
_log_checkpoint_recovery_check # redo blocks to verify after checkpoint 0 TRUE
_log_debug_multi_instance debug redo multi instance code FALSE TRUE
_log_entry_prebuild_threshold redo entries larger than this will be prebuilt before getting la 0 TRUE
_log_io_size automatically initiate log write if this many redo blocks in buf 0 TRUE
_log_space_errors should we report space errors to alert log TRUE TRUE
_max_exponential_sleep max sleep during exponential backoff 0 TRUE
_max_sleep_holding_latch max time to sleep while holding a latch 4 TRUE
_messages message queue resources - dependent on # processes & # buffers 1015 FALSE
_minimum_giga_scn Minimum SCN to start with in 2^30 units 0 TRUE
_mts_fastpath dispatcher network fastpath TRUE TRUE
_mts_listener_retry listener connection retry rate (secs) 120 TRUE
_mts_load_constants server load balancing constants (S,P,D,I) 3,0.75,0.25,0.1 TRUE
_number_cached_attributes maximum number of cached attributes per instance 10 TRUE
_offline_rollback_segments offline undo segment list   TRUE
_optimizer_undo_changes undo changes to query optimizer FALSE TRUE
_oracle_trace_events Oracle TRACE event flags   TRUE
_oracle_trace_facility_version Oracle TRACE facility version   TRUE
_parallel_allocation allocation method for parallel query servers wide TRUE
_parallel_min_message_pool minimum size of shared pool memory to reserve for pq servers 19332 FALSE
_parallel_server_sleep_time sleep time between dequeue timeouts (in 1/100ths) 10 TRUE
_passwordfile_enqueue_timeout password file enqueue timeout in seconds 900 TRUE
_plsql_dump_buffer_events conditions upon which the PL/SQL circular buffer is dumped   TRUE
_release_insert_threshold maximum number of unusable blocks to unlink from freelist 5 TRUE
_reuse_index_loop number of blocks being examine for index block reuse 5 TRUE
_rollback_segment_count number of undo segments 0 TRUE
_rollback_segment_initial starting undo segment number 1 TRUE
_row_cache_buffer_size size of row cache circular buffer 200 TRUE
_row_cache_instance_locks number of row cache instance locks 100 TRUE
_session_idle_bit_latches one latch per session or a latch per group of sessions 0 TRUE
_shared_session_sort_fetch_buffer size of in-memory merge buffer for mts or xa fetch calls 0 TRUE
_single_process run without detached processes FALSE TRUE
_small_table_threshold threshold level of table size for forget-bit enabled during scan 512 FALSE
_sql_connect_capability_override SQL Connect Capability Table Override 0 TRUE
_sql_connect_capability_table SQL Connect Capability Table (testing only)   TRUE
_standby_lock_name_space lock name space used for generating lock names for standby datab   TRUE
_star_transformation_enabled enable the use of semi-join transformations FALSE TRUE
_test_param_1 test parmeter 1 25 TRUE
_test_param_2 test parameter 2   TRUE
_test_param_3 test parameter 3   TRUE
_trace_archive_dest trace archival destination ?/rdbms/log TRUE
_trace_archive_start start trace process on SGA initialization FALSE TRUE
_trace_block_size trace block size 2048 TRUE
_trace_buffers_per_process trace buffers per process 0 TRUE
_trace_enabled Should tracing be enabled at startup TRUE TRUE
_trace_events turns on and off trace events   TRUE
_trace_file_size trace file size 10000 TRUE
_trace_files_public Create publicly accessible trace files TRUE FALSE
_trace_flushing TRWR should try to keep tracing buffers clean FALSE TRUE
_trace_instance_termination trace instance termination actions FALSE TRUE
_trace_write_batch_size trace write batch size 32 TRUE
_wait_for_sync wait for sync on commit MUST BE ALWAYS TRUE TRUE TRUE
_wakeup_timeout wakeup monitor timeout value 100 TRUE
_walk_insert_threshold maximum number of unusable blocks to walk across freelist 0 TRUE
always_anti_join always use this anti-join when possible NESTED_LOOPS FALSE
async_write Disable/Enable Async Write TRUE TRUE
audit_file_dest Directory in which auditing files are to reside ?/rdbms/audit TRUE
audit_trail enable system auditing NONE FALSE
b_tree_bitmap_plans enable the use of bitmap plans for tables w. only B-tree indexes FALSE TRUE
background_core_dump Core Size for Background Processes full TRUE
background_dump_dest Detached process dump directory /oracle/admin/TESTDB1/bdump FALSE
bitmap_merge_area_size maximum memory allow for BITMAP MERGE 1048576 TRUE
blank_trimming blank trimming semantics parameter FALSE TRUE
cache_size_threshold maximum size of table or piece to be cached (in blocks) 100 FALSE
ccf_io_size Number of bytes per write when creating contiguous file 262144 TRUE
checkpoint_process create a separate checkpoint process TRUE FALSE
cleanup_rollback_entries no. of undo entries to apply per transaction cleanup 20 TRUE
close_cached_open_cursors close cursors cached by PL/SQL at each commit FALSE TRUE
commit_point_strength Bias this node has toward not preparing in a two-phase commit 1 TRUE
compatible Database will be completely compatible with this software versio 7.3.2 FALSE
compatible_no_recovery Database will be compatible unless crash or media recovery is ne   TRUE
control_files control file names list /v01/dbs/TESTDB1.cntrl.01.dbf, /v01/dbs/TESTDB1.cntrl.02.dbf FALSE
core_dump_dest Core dump directory /oracle/admin/TESTDB1/cdump FALSE
cpu_count number of cpu's for this instance 4 FALSE
create_bitmap_area_size size of create bitmap buffer for bitmap index 8388608 TRUE
cursor_space_for_time use more memory in order to get faster execution FALSE TRUE
db_block_buffers Number of database blocks cached in memory 1000 FALSE
db_block_checkpoint_batch Max number of blocks to checkpoint in a DB Writer IO 8 TRUE
db_block_checksum store checksum in db blocks and check during reads FALSE TRUE
db_block_lru_extended_statistics Maintain buffer cache LRU statistics for last N blocks discarded 0 TRUE
db_block_lru_latches number of lru latches 2 FALSE
db_block_lru_statistics Maintain buffer cache LRU hits-by-position statistics (slow) FALSE TRUE
db_block_size Size of database block in bytes 8192 FALSE
db_domain directory part of global database name stored with CREATE DATABA WORLD TRUE
db_file_multiblock_read_count db block to be read each IO 8 TRUE
db_file_simultaneous_writes max simultaneous (overlaped) writes per db file 2 FALSE
db_file_standby_name_convert datafile name convert pattern and string for standby database   TRUE
db_files max allowable # db files 128 FALSE
db_name database name specified in CREATE DATABASE TESTDB1 FALSE
db_writers Number of database writer processes 2 FALSE
dblink_encrypt_login enforce password for distributed login always be encrypted FALSE TRUE
delayed_logging_block_cleanouts turn on delayed-logging block cleanouts feature TRUE TRUE
discrete_transactions_enabled enable OLTP mode FALSE TRUE
distributed_lock_timeout number of seconds a distributed transaction waits for a lock 3600 FALSE
distributed_recovery_connection_hold_time number of seconds RECO holds outbound connections open 200 TRUE
distributed_transactions max. number of concurrent distributed transactions 150 FALSE
dml_locks dml locks - one for each table modified in a transaction 100 FALSE
enqueue_resources resources for enqueues 2000 FALSE
event debug event control - default null string   TRUE
fast_cache_flush enable fast cache flush for parallel query FALSE TRUE
fixed_date fixed SYSDATE value   TRUE
gc_db_locks # DB locks (DFS) 100 TRUE
gc_files_to_locks Mapping between file numbers and hash buckets   TRUE
gc_freelist_groups # freelist groups locks in (DFS) 50 FALSE
gc_lck_procs number of background parallel server lock processes to start 1 TRUE
gc_releasable_locks # releasable DB locks (DFS) 1000 FALSE
gc_rollback_locks # Undo locks in (DFS) 20 TRUE
gc_rollback_segments # Undo Segments 20 TRUE
gc_save_rollback_locks # Save Undo locks in (DFS) 20 TRUE
gc_segments # Segment headers 10 TRUE
gc_tablespaces # tablespaces 5 TRUE
global_names enforce that database links have same name as remote database FALSE TRUE
hash_area_size size of in-memory hash work area 0 TRUE
hash_join_enabled enable/disable hash join TRUE TRUE
hash_multiblock_io_count number of blocks hash join will read/write at once 1 TRUE
ifile include file in init.ora   TRUE
instance_number instance number 0 TRUE
job_queue_interval Wakeup interval in seconds for job queue processes 60 TRUE
job_queue_keep_connections Keep network connections between execution of jobs FALSE TRUE
job_queue_processes number of job queue processes to start 2 FALSE
license_max_sessions maximum number of non-system user sessions allowed 0 TRUE
license_max_users maximum number of named users that can be created in the databas 0 TRUE
license_sessions_warning warning level for number of non-system user sessions 0 TRUE
log_archive_buffer_size Size of each archival buffer in log file blocks 127 TRUE
log_archive_buffers Number of buffers to allocate for archiving 4 TRUE
log_archive_dest archival destination text string /archive01/TESTDB1.arch.log FALSE
log_archive_format archival destination format %t_%s.dbf TRUE
log_archive_start start archival process on SGA initialization FALSE TRUE
log_block_checksum calculate checksum for redo blocks when writing FALSE TRUE
log_buffer redo circular buffer size 262144 FALSE
log_checkpoint_interval # redo blocks checkpoint threshold 1024000 FALSE
log_checkpoint_timeout Maximum time interval between checkpoints in seconds 3600 FALSE
log_checkpoints_to_alert log checkpoint begin/end to alert file FALSE TRUE
log_file_standby_name_convert logfile name convert pattern and string for standby database   TRUE
log_files max allowable # log files 255 TRUE
log_simultaneous_copies number of simultaneous copies into redo buffer(# of copy latches 16 FALSE
log_small_entry_max_size redo entries larger than this will acquire the redo copy latch 180 FALSE
max_commit_propagation_delay Max age of new snapshot in .01 seconds 90000 TRUE
max_dump_file_size Maximum size (blocks) of dump file 10240 FALSE
max_enabled_roles max number of roles a user can have enabled 20 TRUE
max_rollback_segments max. number of rollback segments in SGA cache 30 TRUE
max_transaction_branches max. number of branches per distributed transaction 8 TRUE
mlock_db_block_buffers lock db buffer SGA pages FALSE TRUE
mlock_log_buffer lock redo buffer SGA pages FALSE TRUE
mts_dispatchers specifications of dispatchers (ADDRESS=(PARTIAL=yes)(PROTOCOL=TCP)),1 FALSE
mts_listener_address address(es) of network listener (ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521)) FALSE
mts_max_dispatchers max number of dispatchers 5 TRUE
mts_max_servers max number of servers 10 FALSE
mts_multiple_listeners Are multiple listeners enabled? FALSE TRUE
mts_servers number of servers to start up 10 FALSE
mts_service service supported by dispatchers TESTDB1 FALSE
nls_currency NLS local currency symbol   TRUE
nls_date_format NLS Oracle date format   TRUE
nls_date_language NLS date language name   TRUE
nls_iso_currency NLS ISO currency territory name   TRUE
nls_language NLS language name AMERICAN TRUE
nls_numeric_characters NLS numeric characters   TRUE
nls_sort NLS linguistic definition name   TRUE
nls_territory NLS territory name AMERICA TRUE
open_cursors max # cursors per process 150 FALSE
open_links max # open links per process 4 TRUE
optimizer_mode optimizer mode RULE FALSE
optimizer_parallel_pass optimizer parallel pass TRUE TRUE
optimizer_percent_parallel optimizer percent parallel 0 TRUE
optimizer_search_limit optimizer search limit 5 TRUE
oracle_trace_collection_name Oracle TRACE default collection name oracle7 TRUE
oracle_trace_collection_path Oracle TRACE collection path ?/rdbms/log TRUE
oracle_trace_collection_size Oracle TRACE collection file max. size 5242880 TRUE
oracle_trace_enable Oracle TRACE instance wide enable/disable FALSE TRUE
oracle_trace_facility_name Oracle TRACE default facility name oracle7 TRUE
oracle_trace_facility_path Oracle TRACE facility path ?/rdbms/admin TRUE
os_authent_prefix prefix for auto-logon accounts   TRUE
os_roles retrieve roles from the operating system FALSE TRUE
parallel_default_max_instances default maximum number of instances for parallel query 0 TRUE
parallel_max_servers maximum parallel query servers per instance 20 FALSE
parallel_min_percent minimum percent of threads required for parallel query 0 TRUE
parallel_min_servers minimum parallel query servers per instance 1 FALSE
parallel_server_idle_time idle time before parallel query server dies 5 TRUE
partition_view_enabled enable/disable partitioned views FALSE TRUE
pre_page_sga pre-page sga for process FALSE TRUE
processes user processes 500 FALSE
recovery_parallelism number of server processes to use for parallel recovery 0 TRUE
reduce_alarm Reduce Alarm FALSE TRUE
remote_dependencies_mode remote-procedure-call dependencies mode parameter timestamp TRUE
remote_login_passwordfile password file usage parameter SHARED FALSE
remote_os_authent allow non-secure remote clients to use auto-logon accounts TRUE FALSE
remote_os_roles allow non-secure remote clients to use os roles FALSE TRUE
resource_limit master switch for resource limit FALSE TRUE
rollback_segments undo segment list ROLLBACK_01 FALSE
row_cache_cursors number of cached cursors for row cache management 50 FALSE
row_locking row-locking always TRUE
sequence_cache_entries number of sequence cache entries 30 FALSE
sequence_cache_hash_buckets number of sequence cache hash buckets 23 FALSE
serializable serializable FALSE TRUE
session_cached_cursors number of cursors to save in the session cursor cache 50 FALSE
sessions user and system sessions 555 FALSE
shadow_core_dump Core Size for Shadow Processes full TRUE
shared_pool_reserved_min_alloc minimum allocation size in bytes for reserved area of shared poo 5000 TRUE
shared_pool_reserved_size size in bytes of reserved area of shared pool 1800000 FALSE
shared_pool_size size in bytes of shared pool 10000000 FALSE
snapshot_refresh_interval Wakeup interval in seconds for job queue processes 60 TRUE
snapshot_refresh_keep_connections Keep network connections between execution of jobs FALSE TRUE
snapshot_refresh_processes number of job queue processes to start 0 TRUE
sort_area_retained_size size of in-memory sort work area retained between fetch calls 100000 FALSE
sort_area_size size of in-memory sort work area 100000 FALSE
sort_direct_writes use direct write TRUE FALSE
sort_read_fac multi-block read factor for sort 5 TRUE
sort_spacemap_size size of sort disk area space map 512 TRUE
sort_write_buffer_size size of each sort direct write buffer 32768 TRUE
sort_write_buffers number of sort direct write buffers 4 FALSE
spin_count Number of times to spin on latch miss 6000 FALSE
sql92_security require select privilege for searched update/delete FALSE TRUE
sql_trace enable SQL trace FALSE TRUE
temporary_table_locks temporary table locks 555 FALSE
text_enable enable text searching FALSE TRUE
thread Redo thread to mount 0 TRUE
timed_statistics maintain internal timing statistics FALSE TRUE
transactions max. number of concurrent active transactions 610 FALSE
transactions_per_rollback_segment number of active transactions per rollback segment 20 FALSE
unlimited_rollback_segments allow unlimited extents for rollback segments FALSE TRUE
use_fast_path_aio Use fast path Async IO to raw disks for DGUX FALSE TRUE
user_dump_dest User process dump directory /oracle/admin/TESTDB1/udump FALSE
utl_file_dir utl_file accessible directories list * FALSE
v733_plans_enabled enable/disable several performance features introduced in 7.3.3 FALSE TRUE

If you receive an error on this report (i.e. ORA-00942: table or view does not exist) than you are probably not running OraSnap as SYS. This script is based directly on the X$ tables, which are only visible to the SYS schema. You can either rerun OraSnap as SYS or setup a view (as SYS) and modify this report (allinitora.sql) to query against the new view.