RE: seen a Select (just a select no select for update) take out a Table Exclusive lock (TX)
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <lawrence.wolfson@xxxxxxxxxx>
- Date: Thu, 26 Jan 2006 17:00:19 -0500
Minor correction, TX is transaction, not table exclusive".
It's possible for a select statement to take a TX lock if it's a
distributed query, i.e., references a remote object via a database link.
Hope that helps,
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfson Larry -
lwolfs
Sent: Thursday, January 26, 2006 4:23 PM
Cc: oracle-l@xxxxxxxxxxxxx
Subject: seen a Select (just a select no select for update) take out a
Table Exclusive lock (TX)
From one of the other DBAs here:
"Have any of you ever seen a Select (just a select no select for update)
take out a Table Exclusive lock (TX) ? we had one in SAP this morning on
ZPICK01 and the developers assure me that the transaction doesn't try to
update the table. The only thing I can think of, is that ZPICK01 is huge
and that Oracle tried to ensure some form of Read Consistency by making
the table TX. That said I'm still not certain that some switch in the
transaction isn't set to lock the table. Thoughts ?"
Gee, I haven't worked much on SAP lately, but I believe tables prefixed
Y and Z are custom tables, although I don't see why that would make a
difference.
Thanks
Larry
************************************************************************
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
************************************************************************
*
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
