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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Timestamp Ordering granularity

Re: Timestamp Ordering granularity

From: Wojtek Narczynski <wojtek_at_power.com.pl>
Date: Fri, 24 Dec 2004 09:37:42 +0000 (UTC)
Message-ID: <cqgo16$2gi$1@nemesis.news.tpi.pl>


Jonathan Leffler wrote:

> If you use TO and assign a single timestamp to a page, then the
> system will treat it as though any transaction that modifies any
> record on the page actually modified every record on the page.
> That's a conservative but safe way of dealing with it.

I understand that, but this limits concurrency. What I would like is to go on page level when contention is low, and fallback to record level when contention gets high.

Regards,
Wojtek Received on Fri Dec 24 2004 - 03:37:42 CST

Original text of this message

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