Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cursor: pin S - mutex Wait - in Benchmark

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

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 16 Nov 2006 21:41:53 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020021440D6@BLRKECMSG11.ad.infosys.com>

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

Received on Thu Nov 16 2006 - 10:11:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US