| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: seen a Select (just a select no select for update) take out a Table Exclusive lock (TX)
Well since you mentioned SAP...
You may want to see if there were any SAP batch jobs running at the same time period --AND-- an ABAP generation was occurring.
The ABAP generation that occurs during the background job will effectively take out exclusive locks...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry -
lwolfs
Sent: Thursday, January 26, 2006 1:23 PM
Cc: oracle-l_at_freelists.org
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*
************************************************************************
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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 26 2006 - 15:26:58 CST
 |
 |