Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: seen a Select (just a select no select for update) take out a Table Exclusive lock (TX)

Re: seen a Select (just a select no select for update) take out a Table Exclusive lock (TX)

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 26 Jan 2006 16:29:22 -0800
Message-ID: <bf46380601261629m1fed932bg83ad255bcf1a3552@mail.gmail.com>


On 1/26/06, Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com> wrote:
>
>
> 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.

The difference would be that custom codes allows the developer the opportunity to include pass through sql.

ie. They can run a lock statement in the database.

Though as you know, a TX enqueue is not a table lock.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 26 2006 - 18:29:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US