Tuning Global Cache - Expert Oracle RAC Performance Diagnostics and Tuning - page 440

pinwait —The block currently experienced wait while pinning block to buffer. Wait time
currently captured in “gc current request.”

•

grant . • Number of grants to the current object in global cache is identified by

GRANTQ rl LOCAL —There was a local grant of resource to the block. •

master 5 is contained in instance 5. • Master of the object identified by

SQL> SELECT OWNER, OBJECT_ID, OBJECT_TYPE FROM dba_objects where object_id=513436;

OWNER OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------------
DWH 513436 INDEX

Event 10430 @ Level 1—Trace Dynamic Remastering
This trace event will capture the remaster requests and transfers on the respective nodes. The trace is recorded in the
LMD trace file.

SQL> ALTER SYSTEM SET EVENTS '10430 trace name context forever, level 1';
System altered.

SQL> ALTER SYSTEM SET EVENTS '10430 trace name context off';
System altered.

Event 10432 @ Level 1—Trace GCS Cache Fusion Calls
This trace event will capture the global cache service fusion calls. The trace files are recorded in the diagnostic
trace directory.

SQL> ALTER SYSTEM SET EVENTS '10432 trace name context forever, level 1';
*** 2010-11-29 15:01:02.000
stale cvak fr 3:0x1122331d98([0x53594e43][0x10],[IV])[h=KJUSERNL,n=KJUSEREX,b=KJUSERNL,ls=KJUSERST
AT_NOVALUE]:0x20004 < 0x0
2010-11-29 15:06:10.319979*: * kjmdm: msgs to be sent for ha phase1 found! (snd_for_p1 1)

*** 2010-11-29 15:06:10.320
2010-11-29 15:06:10.319979*: * kjmsp1 called, msgs to send, p2ack dump at beginning:
2010-11-29 15:06:10.319979*:
* Begin dump saved p2ack info:
* p2id 67.8, ack count 1, valid 1, ready 1
* to 2, subt 1, cvt lvl 5, is_cvt_b 0, maxs 784
2010-11-29 15:06:10.319979*:
* End dump saved p2ack info
2010-11-29 15:06:10.319979*: * kjmsp1: p2ack p2id 67.8 ready for sending
2010-11-29 15:06:10.319979*: * kjmsp1: will send KJX_HA_P2 msg to 3
2010-11-29 15:06:10.319979*: * subtype 1, p2id 67.8, cvt lvl x5, is cvt blkr 0, maxsessions 784
2010-11-29 15:06:10.319979*:
* kjurn[0] = x4c4f434b