RE: SQL Query causing "gc buffer busy " or Not ?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <VIVEK_SHARMA@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of VIVEK_SHARMA
Sent: Thursday, February 21, 2008 9:36 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQL Query causing "gc buffer busy " or Not ?
Folks
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
Cheers
Vivek
P.S.
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
e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
