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

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