Hi,
As part of performance tuning ,app team wants to set following changes in the Linux and Oracle DB.
Could you please review the below points and confirm change requestor that I have mentioned below corresponding to each changes.
I am not sure if these changes/settings can be done on the DB server. So could you please confirm if these settings can be done on the server?
or please provide me some reference materials to view it.
a. Implement Linux Huge Pages -- To be done by Unix admin?
b. Oracle Initialization Parameters -- To be done by Oracle admin? -- Please refer to below DB parameters
c. Reconfigure the Kernel Settings -- To be done by Unix admin?
d. Reconfigure the redo-logs -- To be done by Unix admin?
•Each File member size 512 MB
•Number of members per group 2
•Number of redo log groups 5
•Plus both members of each group should be separated onto distinct file systems within the SAN to avoid contention and provide optimum resiliency.
e.Implement Buffer pooling: -- To be done by Oracle admin? -- Looks they want to some SQl query that once executed will assign all the Enovia segments to the appropriate buffer pool.
f. Rebuild the indexes -- To be done by Oracle admin?
g. Automate and Secure Schema Statistic Generations -- To be done by Oracle admin?
Here are the DB parameters app team wants to set in the DB pfile.
smtp_out_server= smtp.nokia.com
filesystemio_options=setall
large_pool_size=64M
backup_tape_io_slaves=TRUE
remote_login_passwordfile=EXCLUSIVE
_b_tree_bitmap_plans=FALSE
_memory_imm_mode_without_autosga=FALSE
cpu_count=0
cursor_sharing=SIMILAR
db_block_checksum=OFF
db_cache_advice=OFF
db_cache_size=40G
db_keep_cache_size=300M
db_writer_processes=1
dml_locks=2000
fast_start_mttr_target=1800
lock_sga=TRUE
open_cursors=150
optimizer_dynamic_sampling=1
optimizer_index_caching=99
optimizer_index_cost_adj=1
pga_aggregate_target=4G
processes=1000
session_cached_cursors=150
shared_pool_size=2000M
trace_enabled=FALSE
use_large_pages=ONLY
Oracle -- 11.2.0.3.0
OS --- Linux
This is standalone DB
Please tell me if you need any information at application / DB end to make things more clear on this.
Regards,
bala