Thursday, December 5, 2013

How to tuning Oracle performance in RAC

Learning points from Oracle Expert
1. Focus on the INSERT, UPDATE and DELETE intensive indexes and tablespace (READS will always scale well)
2. Focus on "write hot spots". Use "non-ordered" with ultra large cache size for sequence, as well as hash partition index/reverse index
3. Random access to database is not an issue,frequently modified small tables are interesting
4. A small subset of statements and objects causes 90% of performance issues
5. Standard SQL and schema tuning solves > 80% of performance problems
6. Standard common sense system tuning practices should be applied
7. Almost everything can be scaled out quickly with load-direction and load balancing via services