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: Db2, Oracle, SQL Server

Re: Db2, Oracle, SQL Server

From: Mark B. Townsend <Mark.Townsend_at_oracle.com>
Date: Thu, 10 Feb 2005 07:43:29 -0800
Message-ID: <3BLOd.28$Lh.82@news.oracle.com>


DA Morgan wrote:
> Mark Townsend wrote:
>

>>  > You don't
>>
>>> want a "select" only system to take row locks all the time, because 
>>> table
>>> locks are much faster. Storing locks in memory is also faster than 
>>> storing
>>> them on the blocks.
>>>
>>
>> Taking read locks at a table level: Faster
>> Storing read locks in memory      : Faster
>> Not taking a read lock at all     : Priceless
>>
>> Sorry. Couldn't resist

>
>
> And you missed a good dinner too.

Sorry. India. Received on Thu Feb 10 2005 - 09:43:29 CST

Original text of this message

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