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: Maximum number of transaction. (Newby question).

Re: Maximum number of transaction. (Newby question).

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 30 Oct 2003 15:43:33 -0000
Message-ID: <3fa131a6$0$9473$ed9e5944@reading.news.pipex.net>


"VC" <boston103_at_hotmail.com> wrote in message news:31e0625e.0310300645.4c908003_at_posting.google.com...
> Hello Ben,
>
> The behaviour you're observing is explained by Oracle 9i's creating
> _two_ ITL slots instead of one despite your specifying 'initrans 1'.
> It can be easily verified by dumping the data block.
>
> If you perform an update #3 on row #3 in addition to the two you've
> already initiated, you'll get the desired effect.

This must be some new definition of the word 'desired' with which I am unfamiliar.

-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk
Received on Thu Oct 30 2003 - 09:43:33 CST

Original text of this message

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