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

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 13 Nov 2012 10:28:29 -0600
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856500F647_at_NADCWPMSGCMS10.hca.corpad.net>



I should mention I did capture the block_id that is being requested: Wait Class <http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

Wait Event<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P1 Text<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P1<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P2 Text<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P2<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P3 Text<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

P3<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

Wait Time (ms)<http://nagrdp01.unix.medcity.net:4889/em/console/database/instance/sessionDetails?event=doLoad&target╠MNASP1_CCMNASP1N1&type=oracle_database&SIDS66&serialNumR506&source=topSessions&pageNum=6&refreshChoice=RT_15>

Other

cr request retry

file#

29

block#

242369

0

0

Cluster

gc cr failure

29

242369

1

0

From: Taylor Christopher - Nashville
Sent: Tuesday, November 13, 2012 10:26 AM To: oracle-l_at_freelists.org
Subject: RAC CR REQUEST RETRY - Which node is holding the data block?

Setup:
10.2.0.4 64-bit
RHEL 3 node RAC
node1 is requesting blocks for a transaction - either node2 or node3 is holding the block(s) that are being requested.

How can I determine which node(s) of the cluster are holding the requested block(s)?

Regards,

Chris Taylor
Oracle DBA
Parallon IT&S
christopher.taylor2_at_parallon.net<mailto:christopher.taylor2_at_parallon.net> www.parallon.net

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 13 2012 - 17:28:29 CET

Original text of this message