Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cursor: pin S - mutex Wait - in Benchmark
Thanks Gopal for responding, as always.
My Qs are Prefixed with "~~Qs~~" below
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
Sent: Thursday, November 16, 2006 9:34 PM
To: VIVEK_SHARMA
Cc: oracle-l
Subject: 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
~~Qs~~ How to check the same? Any Sample SQL, Link, Doc?
~~Qs~~ Is your sentence above incomplete? Are you trying to advise
Manually master the Local objects in the Local Node?
--
Best Regards,
K Gopalakrishnan
![]() |
![]() |