Review Parameters

Hello All,

Please review the following values of paramter on the server. and give
your suggesstion for imporving the performance.


NAME VALUE

------------------------- --------------------------------

processes 150

sessions 170

timed_statistics TRUE =----- SHould be false

timed_os_statistics 0

resource_limit FALSE

license_max_sessions 0

license_sessions_warning 0

cpu_count 2

instance_groups

event

shared_pool_size 268435456

sga_max_size 706185456

shared_pool_reserved_size 13421772

large_pool_size 16777216

java_pool_size 117440512

java_soft_sessionspace_li 0

mit



java_max_sessionspace_siz 0

e



pre_page_sga FALSE

shared_memory_address 0

hi_shared_memory_address 0

use_indirect_data_buffers FALSE

lock_sga FALSE

spfile ?/dbs/spfile@.ora

lock_name_space

enqueue_resources 968

trace_enabled TRUE

nls_language AMERICAN

nls_territory AMERICA

nls_sort

nls_date_language

nls_date_format

nls_currency

nls_numeric_characters

nls_iso_currency

nls_calendar

nls_time_format

nls_timestamp_format

nls_time_tz_format

nls_timestamp_tz_format

nls_dual_currency

nls_comp

nls_length_semantics BYTE

nls_nchar_conv_excp FALSE

filesystemio_options asynch

disk_asynch_io TRUE

tape_asynch_io TRUE

dbwr_io_slaves 0

backup_tape_io_slaves FALSE

resource_manager_plan

cluster_interconnects

file_mapping FALSE

active_instance_count

control_files /db39i/oradata/test9i/control01.

ctl, /db39i/oradata/test9i/contr

ol02.ctl, /oracle/ora9ir2/oradat

a/test9i/control03.ctl



db_file_name_convert

log_file_name_convert

db_block_buffers 0

db_block_checksum TRUE

db_block_size 8192

db_writer_processes 1

db_keep_cache_size 0

db_recycle_cache_size 0

db_2k_cache_size 0

db_4k_cache_size 0

db_8k_cache_size 0

db_16k_cache_size 0

db_32k_cache_size 0

db_cache_size 268435456

buffer_pool_keep

buffer_pool_recycle

db_cache_advice ON

max_commit_propagation_de 700

lay



compatible 9.2.0.0.0

remote_archive_enable true

log_archive_start FALSE

log_archive_dest

log_archive_duplex_dest

log_archive_dest_1

log_archive_dest_2

log_archive_dest_3

log_archive_dest_4

log_archive_dest_5

log_archive_dest_6

log_archive_dest_7

log_archive_dest_8

log_archive_dest_9

log_archive_dest_10

log_archive_dest_state_1 enable

log_archive_dest_state_2 enable

log_archive_dest_state_3 enable

log_archive_dest_state_4 enable

log_archive_dest_state_5 enable

log_archive_dest_state_6 enable

log_archive_dest_state_7 enable

log_archive_dest_state_8 enable

log_archive_dest_state_9 enable

log_archive_dest_state_10 enable

log_archive_max_processes 2

log_archive_min_succeed_d 1

est



standby_archive_dest ?/dbs/arch

log_archive_trace 0

fal_server

fal_client

log_archive_format %t_%s.dbf

log_buffer 524288

log_checkpoint_interval 0

log_checkpoint_timeout 1800

archive_lag_target 0

log_parallelism 1

db_files 200

db_file_multiblock_read_c 8

ount



read_only_open_delayed FALSE

cluster_database FALSE

parallel_server FALSE

parallel_server_instances 1

cluster_database_instance 1

s



db_create_file_dest

db_create_online_log_dest

_1



db_create_online_log_dest

_2



db_create_online_log_dest

_3



db_create_online_log_dest

_4



db_create_online_log_dest

_5



standby_file_management MANUAL

gc_files_to_locks

thread 0

fast_start_io_target 0

fast_start_mttr_target 300

log_checkpoints_to_alert FALSE

recovery_parallelism 0

control_file_record_keep_ 7

time



logmnr_max_persistent_ses 1

sions



dml_locks 748

row_locking always

serializable FALSE

replication_dependency_tr TRUE

acking



instance_number 0

transactions 187

transactions_per_rollback 5

_segment



max_rollback_segments 37

rollback_segments

transaction_auditing TRUE

undo_management AUTO

undo_tablespace UNDOTBS1

undo_suppress_errors FALSE

undo_retention 10800

fast_start_parallel_rollb LOW

ack



db_block_checking FALSE

os_roles FALSE

rdbms_server_dn

max_enabled_roles 30

remote_os_authent FALSE

remote_os_roles FALSE

O7_DICTIONARY_ACCESSIBILI FALSE

TY



remote_login_passwordfile EXCLUSIVE

dblink_encrypt_login FALSE

license_max_users 0

global_context_pool_size

audit_sys_operations FALSE

db_domain

global_names FALSE

distributed_lock_timeout 60

commit_point_strength 1

instance_name test9i

service_names test9i

dispatchers (PROTOCOL=TCP) (SERVICE=test9iXD

B)



mts_dispatchers (PROTOCOL=TCP) (SERVICE=test9iXD

B)



shared_servers 1

mts_servers 1

max_shared_servers 20

mts_max_servers 20

max_dispatchers 5

mts_max_dispatchers 5

circuits 170

mts_circuits 170

shared_server_sessions 165

mts_sessions 165

local_listener

remote_listener

mts_service test9i

mts_listener_address

mts_multiple_listeners FALSE

serial_reuse DISABLE

cursor_space_for_time FALSE

session_cached_cursors 0

remote_dependencies_mode TIMESTAMP

utl_file_dir

plsql_v2_compatibility FALSE

plsql_compiler_flags INTERPRETED

plsql_native_c_compiler

plsql_native_linker

plsql_native_library_dir

plsql_native_make_utility

plsql_native_make_file_na

me



plsql_native_library_subd 0

ir_count



job_queue_processes 0

parallel_min_percent 0

create_bitmap_area_size 8388608

bitmap_merge_area_size 1048576

cursor_sharing EXACT

parallel_min_servers 0

parallel_max_servers 5

parallel_instance_group

parallel_execution_messag 2152

e_size



hash_join_enabled TRUE

hash_area_size 104857600

shadow_core_dump partial

background_core_dump partial

background_dump_dest /db39i/admin/test9i/bdump

user_dump_dest /db39i/admin/test9i/udump

max_dump_file_size UNLIMITED

core_dump_dest /db39i/admin/test9i/cdump

audit_file_dest ?/rdbms/audit

oracle_trace_enable FALSE

oracle_trace_facility_pat ?/otrace/admin/fdf

h



oracle_trace_collection_p ?/otrace/admin/cdf

ath



oracle_trace_facility_nam oracled

e



oracle_trace_collection_n

ame



oracle_trace_collection_s 5242880

ize



object_cache_optimal_size 102400

object_cache_max_size_per 10

cent



session_max_open_files 10

open_links 4

open_links_per_instance 4

optimizer_features_enable 8.1.7

fixed_date

audit_trail NONE

sort_area_size 104857600

sort_area_retained_size 0

db_name test9i

open_cursors 6000

ifile

sql_trace FALSE

os_authent_prefix ops$

optimizer_mode CHOOSE

sql92_security FALSE

blank_trimming FALSE

partition_view_enabled FALSE

star_transformation_enabl FALSE

ed



_push_join_predicate FALSE

parallel_adaptive_multi_u FALSE

ser



parallel_threads_per_cpu 2

parallel_automatic_tuning FALSE

optimizer_max_permutation 80000

s



optimizer_index_cost_adj 100

optimizer_index_caching 0

query_rewrite_enabled FALSE

query_rewrite_integrity enforced

sql_version NATIVE

pga_aggregate_target 157286400

workarea_size_policy AUTO

optimizer_dynamic_samplin 0

g



statistics_level TYPICAL

aq_tm_processes 0

hs_autoregister TRUE

dg_broker_start FALSE

drs_start FALSE

dg_broker_config_file1 ?/dbs/dr1@.dat

dg_broker_config_file2 ?/dbs/dr2@.dat

olap_page_pool_size 33554432



With Warm regards
Jatinder SIngh

.