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

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.

Rgds.

"ben brugman" <ben_at_niethier.nl> wrote in message news:<3fa0f04d$0$245$4d4ebb8e_at_read.news.nl.uu.net>...
> At the moment I am playing around with an Oracle database.
>
> I have set The number of transactions for a test table
> initial to 1 and maximum to 1.
> I enter 3 small rows into a table.
> (All rows end up in the same block, when selecting with rowid
> all is the same except that the last digit becomes A or B or C).
>
> Now I open a session and do an update on the first row.
> I open a second session and do an update on the second row.
>
> Both updates succeede and I can commit both.
> Because of the only one transaction in a block I would expect that
> one transaction would be blocked by the first.
>
> What am I missing or understanding wrongly.
>
> ben brugman
Received on Thu Oct 30 2003 - 08:45:23 CST