Re: cursor: pin S - mutex Wait - in Benchmark
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Thu, 16 Nov 2006 20:26:26 -0800 (PST)
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@xxxxxxxxxxx>
To: kaygopal@xxxxxxxxx
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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?
Other related posts:
