Thanks for the answer ANJO, "Besides that pcfree/pctused will determine when blocks are put on the freelist and when not. So probably what you want is multiple freelists to take care of single freelist contention."
Let me ask you something about this. The problem of having a small gap between PCTFREE/PCTUSED is that when a DML hits a block, there's a good chance that this block has to be moved in or out from one of the freelists. This would generate contention on the HEADER BLOCK of the table (where ALL the freelists reside). So I think that by increasing the number of freelists I wouldn't be able to eliminate the contention (BBW waits) over the segment header. Am I right about this? I assume that there must be some DML on this table, I really cant tell as the audit is not on. How can I find out the concurrent number of updates in a table? db_block_size=8K thank you Pablo _______________________________________________________________ Do You Yahoo!? Yahoo! Messenger Comunicaci�n instant�nea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
