| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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
Received on Fri Apr 28 2006 - 06:59:48 CDT
 |
 |