RE: RAC CR REQUEST RETRY - Which node is holding the data block?

From: <Christopher.Taylor2_at_parallon.net>
Date: Wed, 14 Nov 2012 11:06:17 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856506B840_at_NADCWPMSGCMS10.hca.corpad.net>



Yep - correct. Those views you give will at least give me some additional insight at the time it occurs though - so thanks again.

Chris

-----Original Message-----

From: Herring Dave - dherri [mailto:Dave.Herring_at_acxiom.com] Sent: Wednesday, November 14, 2012 11:04 AM To: Taylor Christopher - Nashville; oracle-l_at_freelists.org Subject: RE: RAC CR REQUEST RETRY - Which node is holding the data block?

Yes, that makes sense. I assume that question is in the context of historical checking, so depending on cache size and activity the blocks may be already flushed by the time you check. Ideally you could use X$OBJECT_AFFINITY_STATISTICS and GV$GCSPFMASTER_INFO to check on stats at the object-level in terms of where it's opened and any DRM activity, but like I mentioned those are object-level, not block level like what you're interested in.

DAVID HERRING
DBA
Acxiom Corporation

EML   dave.herring_at_acxiom.com
TEL    630.944.4762
MBL   630.430.5988

1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 14 2012 - 18:06:17 CET

Original text of this message