Re: cursor: pin S - mutex Wait - in Benchmark

Vivek,

Data Partitions can have much bigger impact on performance in RAC as starting from 10g we do the mastering ( and dynamic remastering) at segment level. Also the L2 bitmaps have instance affinity which also helps the local node to grow (or access) the local L1 bitmap blocks.

Just see whether the local objects are mastered in the local node, or you can manually master th

--

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006 http://www.amazon.com/gp/product/007146509X/

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 16 2006 - 10:04:24 CST