首页 > Linux操作系统 > Linux操作系统 > some suggestions for rac performance

some suggestions for rac performance

原创 Linux操作系统 作者:ad007520 时间:2012-05-09 23:10:19 0 删除 编辑
1. If possible, please use CACHE + NOORDER for sequences on RAC:
This setting has the least performance impact on RAC, and it is the default when creating a new sequence wihtout options. Each instances caches a distinct set of numbers in the shared pool. Sequences will not be globally ordered, and gaps will occur when the shared pool is refreshed (e.g. instance shut down) like on single instance databases.

Please refer below note for details:
RAC and Sequences (Doc ID 853652.1)

2. Using table/index partitioning to reduce inter-instance contention.
o Range or list partitioning may be very effective in conjunction with data dependent routing, if the workload can be directed to modules from a particular instance.
o Hash partitioning may help to reduce buffer busy contention by making buffer access distribution patterns sparser, allowing more buffers to be available for concurrent access

3. Configure network settings at the OS to reduce 'gc cr multi block request' waits. See your OS specific documentation for instructions on how
to do this. If using UDP, make sure the parameters relating to send buffer space, receive buffer space, send highwater, and receive highwater are set well above the OS default. The alert.log will indicate what protocol is being used.


Sun (UDP Protcol)
UDP related OS parameters can be queried with the following command:
ndd /dev/udp udp_xmit_hiwat
ndd /dev/udp udp_recv_hiwat
ndd /dev/udp udp_max_buf
Set the udp_xmit_hiwat and udp_recv_hiwat to the OS maximum with:
ndd -set /dev/udp udp_xmit_hiwat
ndd -set /dev/udp udp_recv_hiwat
ndd -set /dev/udp udp_max_buf <1M or higher>

4. Using Parallel Instance Groups

If you want to limit the parallel execution within one instance or a group of instances, you should establish the group membership by setting the INSTANCE_GROUPS and the PARALLEL_INSTANCE_GROUP init.ora parameters.

5. The use of locally managed tablespaces (instead of dictionary managed) with
the 'SEGMENT SPACE MANAGEMENT AUTO' option can reduce dictionary and freelist
block contention.

See below note for details:
Tuning Inter-Instance Performance in RAC and OPS (Doc ID 181489.1)

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量