15-SEP-2007 14:11:21

TESTDB1

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