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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment