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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 29 Aug 2005 09:28:03 -0700
Message-ID: <1125332832.768272@yasure>


Andreas Sheriff wrote:

> "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.

That was my suspicion.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 29 2005 - 11:28:03 CDT

Original text of this message

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