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@xxxxxxxxxxxxx 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@xxxxxxxxxxxx<mailto:christopher.taylor2@xxxxxxxxxxxx> www.parallon.net -- //www.freelists.org/webpage/oracle-l
