Re: PCTFREE and PCTUSED

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: p_rodri99_at_yahoo.es
>
> 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: ListGuru_at_fatcity.com (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: anjo_at_oraperf.com

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: ListGuru_at_fatcity.com (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).