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: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 16 Nov 2006 20:26:26 -0800 (PST)
Message-ID: <20061117042627.48837.qmail@web57001.mail.re3.yahoo.com>


Vivek, If you can wait for another week you can find the answers in the booksheves. Resource Management in Real Application Clusters are discussed in greater details in chapter 11 (not the legal 'chapter 11' btw) my new RAC Book. However it may take more than a week to get the book in your hands. So here are the short answers. For a known resource you can query the X$KJBR to find out the master node for tha resource. X$KJBL.KJBRMASTER shows the master node , and it starts with 0. You can manually remaster an object to a node using oradebug lkdebug -a <pkey>, wher pkey is the data_object_id of the object you want to transfer the mastership. -Gopal Author: Oracle Database 10g RAC Handbook, Oracle Press 2006 http://www.amazon.com/gp/product/007146509X/ ----- Original Message ---- From: VIVEK_SHARMA <VIVEK_SHARMA@infosys.com> To: kaygopal@gmail.com Cc: oracle-l <oracle-l@freelists.org> Sent: Thursday, 16 November, 2006 8:11:53 AM Subject: 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@freelists.org [mailto:oracle-l-bounce@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?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 16 2006 - 22:26:26 CST

Original text of this message

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