26.10.2010

RAC Tuning Tips

- Tuning single instance first
- SQL Tuning is most beneficial
- Buffer cache size is very important
- Use sequence cache
- Use partition table
- Reduce long full table scan (OLTP)
- Use selective,correct index
- Use automatic segment space management
- Private Network/Interconnect 1/10 Gbit Ethernet Infiniband


Hiç yorum yok: