Hi! After recalling, reading my notes and books a little, I found that it was noted in Jonathan Lewis'es Optimising Oracle seminar materials. But yeah, I did not see it mentioned in any Oracle docs, but I think it's more like a documentation bug, not Oracle feature, the blocks sizes are generally quite large now anyway and additional 24 bytes per block isn't such overhead either to support more concurrency for many databases here built with default configuration.
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 1:49 AM > BINGO! I tried 3 tx and #3 waited on a tx to end. > I just RTFMed and the doc (both r1 and r2) says it can be 1 to 255. If you can recall where you read this, please let me know. > > Daniel > > Tanel Poder wrote: > > > Hi! > > > > I remember from somewhere that in 9i, mintrans is 2 for tables as well, like > > for indexes in past. Thus maxtrans is minimum 2 as well, even if you set it > > to 1 explicitly. You can verify it from blockdump, there's 2 ITL entries in > > block even when you have had only one transaction there. So you should try > > to do at least 3 *updates or deletes* in different transactions in a block. > > If you do inserts then a new block is just allocated when ITL list is > > full... > > > > Tanel. > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, August 20, 2003 12:19 AM > > > > > 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 > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Tanel Poder > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
