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: oracle timesten

Re: oracle timesten

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Tue, 21 Nov 2006 16:41:06 +0100
Message-ID: <4ef2fbf50611210741m473e04cfs1059c365ba38b9ab@mail.gmail.com>


This looks like lock escalation to the "block" level, (or simply lock granularity = block), not write consistency ?

Interesting fact either way, thanks for pointing it out :)

> A simplest test:
>
> a) create table with single column (for example) without indexes and
> fill it with 2 rows with different values
> b) in session#1 update the first (yep, i know about order by :o)
> inserted row, do not commit
> c) try to update the second row in session#2 - session is blocked
>
> We've also played with a "range scan" of nonunique indexed column of
> two-column table, just to be sure that there is nothing special in "FULL
> SCAN".

-- 
Alberto Dell'Era
"Per aspera ad astra"
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 21 2006 - 09:41:06 CST

Original text of this message

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