In testing, I found that MAXTRANS seems to be ignored in 9.2.0.3. I created a table with a MAXTRANS setting of 1. I inserted some rows and committed. In one session, I updated a row, but did not commit. In another session, I updated a different row (in the same block). I expected to see a wait, but the transaction completed immediately. I dumped the block header and, sure enough, there were 2 entries in the ITL. There should be only 1 entry (as defined by MAXTRANS).
Am I missing something? or have I hit an 'undocumented feature'? Daniel
begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;;;;;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard
