|
INIT.ORA Parameters
|
| Parameter (1) |
Value |
Is Default |
Session Modifiable |
System Modifiable |
Is Modified |
| always_anti_join |
NESTED_LOOPS |
FALSE |
FALSE |
FALSE |
FALSE |
| async_write |
TRUE |
TRUE |
FALSE |
FALSE |
FALSE |
| audit_file_dest |
?/rdbms/audit |
TRUE |
FALSE |
FALSE |
FALSE |
| audit_trail |
NONE |
FALSE |
FALSE |
FALSE |
FALSE |
| b_tree_bitmap_plans |
FALSE |
TRUE |
TRUE |
FALSE |
FALSE |
| background_core_dump |
full |
TRUE |
FALSE |
FALSE |
FALSE |
| background_dump_dest |
/oracle/admin/TESTDB1/bdump |
FALSE |
FALSE |
FALSE |
FALSE |
| bitmap_merge_area_size |
1048576 |
TRUE |
FALSE |
FALSE |
FALSE |
| blank_trimming |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| cache_size_threshold |
100 |
FALSE |
FALSE |
FALSE |
FALSE |
| ccf_io_size |
262144 |
TRUE |
FALSE |
FALSE |
FALSE |
| checkpoint_process |
TRUE |
FALSE |
FALSE |
FALSE |
FALSE |
| cleanup_rollback_entries |
20 |
TRUE |
FALSE |
FALSE |
FALSE |
| close_cached_open_cursors |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| commit_point_strength |
1 |
TRUE |
FALSE |
FALSE |
FALSE |
| compatible |
7.3.2 |
FALSE |
FALSE |
FALSE |
FALSE |
| compatible_no_recovery |
|
TRUE |
FALSE |
FALSE |
FALSE |
| control_files |
/v01/dbs/TESTDB1.cntrl.01.dbf, /v01/dbs/TESTDB1.cntrl.02.dbf |
FALSE |
FALSE |
FALSE |
FALSE |
| core_dump_dest |
/oracle/admin/TESTDB1/cdump |
FALSE |
FALSE |
FALSE |
FALSE |
| cpu_count |
4 |
FALSE |
FALSE |
FALSE |
FALSE |
| create_bitmap_area_size |
8388608 |
TRUE |
FALSE |
FALSE |
FALSE |
| cursor_space_for_time |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| db_block_buffers |
1000 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_block_checkpoint_batch |
8 |
TRUE |
FALSE |
FALSE |
FALSE |
| db_block_checksum |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| db_block_lru_extended_statistics |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| db_block_lru_latches |
2 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_block_lru_statistics |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| db_block_size |
8192 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_domain |
WORLD |
TRUE |
FALSE |
FALSE |
FALSE |
| db_file_multiblock_read_count |
8 |
TRUE |
TRUE |
IMMEDIATE |
FALSE |
| db_file_simultaneous_writes |
2 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_file_standby_name_convert |
|
TRUE |
FALSE |
FALSE |
FALSE |
| db_files |
128 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_name |
TESTDB1 |
FALSE |
FALSE |
FALSE |
FALSE |
| db_writers |
2 |
FALSE |
FALSE |
FALSE |
FALSE |
| dblink_encrypt_login |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| delayed_logging_block_cleanouts |
TRUE |
TRUE |
FALSE |
FALSE |
FALSE |
| discrete_transactions_enabled |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| distributed_lock_timeout |
3600 |
FALSE |
FALSE |
FALSE |
FALSE |
| distributed_recovery_connection_hold_time |
200 |
TRUE |
FALSE |
FALSE |
FALSE |
| distributed_transactions |
150 |
FALSE |
FALSE |
FALSE |
FALSE |
| dml_locks |
100 |
FALSE |
FALSE |
FALSE |
FALSE |
| enqueue_resources |
2000 |
FALSE |
FALSE |
FALSE |
FALSE |
| event |
|
TRUE |
FALSE |
FALSE |
FALSE |
| fast_cache_flush |
FALSE |
TRUE |
TRUE |
FALSE |
FALSE |
| fixed_date |
|
TRUE |
FALSE |
FALSE |
FALSE |
| gc_db_locks |
100 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_files_to_locks |
|
TRUE |
FALSE |
FALSE |
FALSE |
| gc_freelist_groups |
50 |
FALSE |
FALSE |
FALSE |
FALSE |
| gc_lck_procs |
1 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_releasable_locks |
1000 |
FALSE |
FALSE |
FALSE |
FALSE |
| gc_rollback_locks |
20 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_rollback_segments |
20 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_save_rollback_locks |
20 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_segments |
10 |
TRUE |
FALSE |
FALSE |
FALSE |
| gc_tablespaces |
5 |
TRUE |
FALSE |
FALSE |
FALSE |
| global_names |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| hash_area_size |
0 |
TRUE |
TRUE |
FALSE |
FALSE |
| hash_join_enabled |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
| hash_multiblock_io_count |
1 |
TRUE |
TRUE |
IMMEDIATE |
FALSE |
| ifile |
|
TRUE |
FALSE |
FALSE |
FALSE |
| instance_number |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| job_queue_interval |
60 |
TRUE |
FALSE |
FALSE |
FALSE |
| job_queue_keep_connections |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| job_queue_processes |
2 |
FALSE |
FALSE |
FALSE |
FALSE |
| license_max_sessions |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| license_max_users |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| license_sessions_warning |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| log_archive_buffer_size |
127 |
TRUE |
FALSE |
FALSE |
FALSE |
| log_archive_buffers |
4 |
TRUE |
FALSE |
FALSE |
FALSE |
| log_archive_dest |
/archive01/TESTDB1.arch.log |
FALSE |
FALSE |
FALSE |
FALSE |
| log_archive_format |
%t_%s.dbf |
TRUE |
FALSE |
FALSE |
FALSE |
| log_archive_start |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| log_block_checksum |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| log_buffer |
262144 |
FALSE |
FALSE |
FALSE |
FALSE |
| log_checkpoint_interval |
1024000 |
FALSE |
FALSE |
IMMEDIATE |
FALSE |
| log_checkpoint_timeout |
3600 |
FALSE |
FALSE |
IMMEDIATE |
FALSE |
| log_checkpoints_to_alert |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| log_file_standby_name_convert |
|
TRUE |
FALSE |
FALSE |
FALSE |
| log_files |
255 |
TRUE |
FALSE |
FALSE |
FALSE |
| log_simultaneous_copies |
16 |
FALSE |
FALSE |
FALSE |
FALSE |
| log_small_entry_max_size |
180 |
FALSE |
FALSE |
IMMEDIATE |
FALSE |
| max_commit_propagation_delay |
90000 |
TRUE |
FALSE |
FALSE |
FALSE |
| max_dump_file_size |
10240 |
FALSE |
TRUE |
FALSE |
FALSE |
| max_enabled_roles |
20 |
TRUE |
FALSE |
FALSE |
FALSE |
| max_rollback_segments |
30 |
TRUE |
FALSE |
FALSE |
FALSE |
| max_transaction_branches |
8 |
TRUE |
FALSE |
FALSE |
FALSE |
| mlock_db_block_buffers |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| mlock_log_buffer |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| mts_dispatchers |
(ADDRESS=(PARTIAL=yes)(PROTOCOL=TCP)),1 |
FALSE |
FALSE |
FALSE |
FALSE |
| mts_listener_address |
(ADDRESS=(PROTOCOL=TCP)(HOST=isserver)(PORT=1521)) |
FALSE |
FALSE |
FALSE |
FALSE |
| mts_max_dispatchers |
5 |
TRUE |
FALSE |
FALSE |
FALSE |
| mts_max_servers |
10 |
FALSE |
FALSE |
FALSE |
FALSE |
| mts_multiple_listeners |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| mts_servers |
10 |
FALSE |
FALSE |
FALSE |
FALSE |
| mts_service |
TESTDB1 |
FALSE |
FALSE |
FALSE |
FALSE |
| nls_currency |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_date_format |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_date_language |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_iso_currency |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_language |
AMERICAN |
TRUE |
FALSE |
FALSE |
FALSE |
| nls_numeric_characters |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_sort |
|
TRUE |
FALSE |
FALSE |
FALSE |
| nls_territory |
AMERICA |
TRUE |
FALSE |
FALSE |
FALSE |
| open_cursors |
150 |
FALSE |
FALSE |
FALSE |
FALSE |
| open_links |
4 |
TRUE |
FALSE |
FALSE |
FALSE |
| optimizer_mode |
RULE |
FALSE |
FALSE |
FALSE |
FALSE |
| optimizer_parallel_pass |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
| optimizer_percent_parallel |
0 |
TRUE |
TRUE |
FALSE |
FALSE |
| optimizer_search_limit |
5 |
TRUE |
TRUE |
FALSE |
FALSE |
| oracle_trace_collection_name |
oracle7 |
TRUE |
FALSE |
FALSE |
FALSE |
| oracle_trace_collection_path |
?/rdbms/log |
TRUE |
FALSE |
FALSE |
FALSE |
| oracle_trace_collection_size |
5242880 |
TRUE |
FALSE |
FALSE |
FALSE |
| oracle_trace_enable |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| oracle_trace_facility_name |
oracle7 |
TRUE |
FALSE |
FALSE |
FALSE |
| oracle_trace_facility_path |
?/rdbms/admin |
TRUE |
FALSE |
FALSE |
FALSE |
| os_authent_prefix |
|
TRUE |
FALSE |
FALSE |
FALSE |
| os_roles |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| parallel_default_max_instances |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| parallel_max_servers |
20 |
FALSE |
FALSE |
FALSE |
FALSE |
| parallel_min_percent |
0 |
TRUE |
TRUE |
FALSE |
FALSE |
| parallel_min_servers |
1 |
FALSE |
FALSE |
FALSE |
FALSE |
| parallel_server_idle_time |
5 |
TRUE |
FALSE |
FALSE |
FALSE |
| partition_view_enabled |
FALSE |
TRUE |
TRUE |
FALSE |
FALSE |
| pre_page_sga |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| processes |
500 |
FALSE |
FALSE |
FALSE |
FALSE |
| recovery_parallelism |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| reduce_alarm |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| remote_dependencies_mode |
timestamp |
TRUE |
FALSE |
FALSE |
FALSE |
| remote_login_passwordfile |
SHARED |
FALSE |
FALSE |
FALSE |
FALSE |
| remote_os_authent |
TRUE |
FALSE |
FALSE |
FALSE |
FALSE |
| remote_os_roles |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| resource_limit |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| rollback_segments |
ROLLBACK_01 |
FALSE |
FALSE |
FALSE |
FALSE |
| row_cache_cursors |
50 |
FALSE |
FALSE |
FALSE |
FALSE |
| row_locking |
always |
TRUE |
FALSE |
FALSE |
FALSE |
| sequence_cache_entries |
30 |
FALSE |
FALSE |
FALSE |
FALSE |
| sequence_cache_hash_buckets |
23 |
FALSE |
FALSE |
FALSE |
FALSE |
| serializable |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| session_cached_cursors |
50 |
FALSE |
FALSE |
FALSE |
FALSE |
| sessions |
555 |
FALSE |
FALSE |
FALSE |
FALSE |
| shadow_core_dump |
full |
TRUE |
FALSE |
FALSE |
FALSE |
| shared_pool_reserved_min_alloc |
5000 |
TRUE |
FALSE |
FALSE |
FALSE |
| shared_pool_reserved_size |
1800000 |
FALSE |
FALSE |
FALSE |
FALSE |
| shared_pool_size |
10000000 |
FALSE |
FALSE |
FALSE |
FALSE |
| snapshot_refresh_interval |
60 |
TRUE |
FALSE |
FALSE |
FALSE |
| snapshot_refresh_keep_connections |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| snapshot_refresh_processes |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| sort_area_retained_size |
100000 |
FALSE |
TRUE |
DEFERRED |
FALSE |
| sort_area_size |
100000 |
FALSE |
TRUE |
DEFERRED |
FALSE |
| sort_direct_writes |
TRUE |
FALSE |
TRUE |
DEFERRED |
FALSE |
| sort_read_fac |
5 |
TRUE |
TRUE |
DEFERRED |
FALSE |
| sort_spacemap_size |
512 |
TRUE |
FALSE |
FALSE |
FALSE |
| sort_write_buffer_size |
32768 |
TRUE |
TRUE |
DEFERRED |
FALSE |
| sort_write_buffers |
4 |
FALSE |
TRUE |
DEFERRED |
FALSE |
| spin_count |
6000 |
FALSE |
FALSE |
FALSE |
FALSE |
| sql92_security |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| sql_trace |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| temporary_table_locks |
555 |
FALSE |
FALSE |
FALSE |
FALSE |
| text_enable |
FALSE |
TRUE |
TRUE |
FALSE |
FALSE |
| thread |
0 |
TRUE |
FALSE |
FALSE |
FALSE |
| timed_statistics |
FALSE |
TRUE |
TRUE |
IMMEDIATE |
FALSE |
| transactions |
610 |
FALSE |
FALSE |
FALSE |
FALSE |
| transactions_per_rollback_segment |
20 |
FALSE |
FALSE |
FALSE |
FALSE |
| unlimited_rollback_segments |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| use_fast_path_aio |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
| user_dump_dest |
/oracle/admin/TESTDB1/udump |
FALSE |
FALSE |
IMMEDIATE |
FALSE |
| utl_file_dir |
* |
FALSE |
FALSE |
FALSE |
FALSE |
| v733_plans_enabled |
FALSE |
TRUE |
TRUE |
FALSE |
FALSE |