FreeLists / oracle-l / Big RAC Benchmark Performance Tips?

["VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>]

Folks



A 4-node RAC BIG benchmark with Oracle 10g / AIX 5.3L using a Hybrid
Banking App. is underway.



Qs1 Does Cache fusion(Traffic between the nodes thru the interconnects)
continue to be an expensive operation in Oracle 10g?

To minimize Cache fusion, Manually Transactions have been grouped such
that transactions accessing different DB Server Nodes access different
respective Table partitions (& NOT the same Table partition). Thus
Different Object BLOCKS are accessed in different DB Server nodes.

NOTE - Partitioning of heavier underlying tables has been done such that
different partitions lie in DIFFERENT Tablespaces (& hence datafiles).



Qs2 Is Low Latency Protocol - LLT protocol (of Veritas) equivalent or
something similar available with GPFS?

Currently default (UDP) is being used.



NOTE - A Past benchmark done by us on SUN using VXFS (Veritas) with both
Low Latency Protocol (LLT) & User Datagram Protocol (UDP, Default)
showed LLT had a 98%  Lower interconnect utilization versus UDP.



Qs3 Any additional init.ora parameters for performance apart from the
following which have been set?



db_writer_processes=16

db_cache_advice=OFF

event='10196 trace name context forever, level 10' (to disable index
skip scan)

_library_cache_advice = FALSE

_log_simultaneous_copies      256

_b_tree_bitmap_plans = FALSE (as NO Bitmap indexes exist)

_check_block_after_checksum   TRUE

_system_trig_enabled          FALSE (Benchmark Has NO need for Triggers)

_wait_for_sync                TRUE





NOTE - Standard features i.e. AUM, Tempfiles & ASSM are being used.



Qs4 Other best practices to deploy?





Will provide Statspack, Other diagnostics info. as needed.



Thanks indeed





Configuration:-



APP & DB machines - P5 series

Application Hybrid - (OLTP + Batch nature of Trans).

Oracle 10.2

AIX 5.3

Filesystem GPFS

Storage Box DS8300

Hardware RAID 1+0

Underlying Hardware Stripe Unit Size 64 KB

Overlying Logical Volume Manager Stripe Unit Size 32 MB (S.A.M.E.)





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
for the use of the addressee(s). If you are not the intended recipient, please 
notify the sender by e-mail and delete the original message. Further, you are 
not to copy, disclose, or distribute this e-mail or its contents to any other 
person and any such actions are unlawful. This e-mail may contain viruses. 
Infosys has taken every reasonable precaution to minimize this risk, but is not 
liable for any damage you may sustain as a result of any virus in this e-mail. 
You should carry out your own virus checks before opening the e-mail or 
attachment. Infosys reserves the right to monitor and review the content of all 
messages sent to or from this e-mail address. Messages sent to or from this 
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***