Bad things will happen, it just a question of how expensive these waits are. I have a feeling that they don't contribute much to the overall performance problem. 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. Are there any inserts happening on this table ? How many concurrent updates are going on ? And what is the blocksize. You might be running out of transaction freelists .....
Anjo. Pablo ksksksk wrote: > I see, Charlie. > Thanks for answering. > > I'm not trying to avoid chained rows, I think that > Buffer busy waits may be ocurring in the header of > this segment because the gap between the PCTUSED and > PCTFREE might be too small. > What I want is to check this and all tables as well > and set this GAP correctly (above the average row size > of the table). > > what do you think? > > BTW > would you mind sharing your PL/SQL code with me? > > Thanks > > _______________________________________________________________ > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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).
