RE: SQL Query causing "gc buffer busy " or Not ?
Date: Thu, 21 Feb 2008 11:10:41 -0500
That would depend to a large extent on whether the block(s) in which the desired row appears are the same block(s) the other instances are inserting into and whether the predicate columns (and possibly selected column(s)) are in a branch of an index with blocks being modified by the inserts.
So it could, but I can't predict whether it will significantly from the facts in evidence.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Thursday, February 21, 2008 9:36 AM To: oracle-l_at_freelists.org
Subject: SQL Query causing "gc buffer busy " or Not ?
If the following SQL is Running ONLY on 1 Node & NOT on Other RAC Nodes, will it contribute to ""gc buffer busy" wait on that Node?
NOTE - However INSERTs happen concurrently to SOD Table from the Other RAC Nodes too using Other SQLs
SELECT field1 FROM SOD
WHERE TABLE_ABBR = :1
and TABLE_KEY = :2
and CONTEXT_SOLID = :3
FOR UPDATE NOWAIT
- CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient,
please notify the sender by e-mail and delete the original message. Further,
you are not to copy, disclose, or distribute this e-mail or its contents to
any other person and any such actions are unlawful. This e-mail may contain
viruses. Infosys has taken every reasonable precaution to minimize this
risk, but is not liable for any damage you may sustain as a result of any
virus in this e-mail. You should carry out your own virus checks before
opening the e-mail or attachment. Infosys reserves the right to monitor and
review the content of all messages sent to or from this e-mail address.
Messages sent to or from this e-mail address may be stored on the Infosys
***INFOSYS******** End of Disclaimer ********INFOSYS***
http://www.freelists.org/webpage/oracle-l Received on Thu Feb 21 2008 - 10:10:41 CST