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

Home -> Community -> Usenet -> c.d.o.server -> Re: What is more costly ?

Re: What is more costly ?

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Sun, 28 Aug 2005 22:45:49 -0700
Message-ID: <XixQe.3162$Ix4.1312@okepread03>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1125252977.724921_at_yasure...
> LineVoltageHalogen wrote:
> > What is the order of costliness with regards to: a.) redo activity,
> > potential lock escalation, etc:
> >
> > inserts, updates, or deletes?
> >
> > Thanks, TFD
>
> Are you refering to Oracle? Lock escalation doesn't exist.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

I think he's thinking SQL Server, which does escalate locks.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.
Received on Mon Aug 29 2005 - 00:45:49 CDT

Original text of this message

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