ben brugman wrote:
>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
>
>
>
You are assuming that your interpretation of MINTRANS and MAXTRANS is as
you
think it is. I'd suggest going to http://tahiti.oracle.com and
researching the subject more.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Oct 30 2003 - 08:41:13 CST
