read some stuff about "free list" and "free list groups"
i think segment header contention is what you are looking for...
> ----------
> From: Jack van Zanen[SMTP:nlzanen1_at_ey.nl]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, August 03, 2000 2:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Data_block waits how to solve
>
>
>
>
> Hi All,
>
>
>
> Following is a print out of the wait events that I have
>
> DB Date / Time
> mm-dd hh:mi Data Block
> ---------- ----------- ----------
> PPRD 08-02 09:00 87
> 08-02 10:00 706
> 08-02 11:00 669
> 08-02 12:00 1717
> 08-02 13:00 3939
> 08-02 14:00 2860
> 08-02 15:00 3082
> 08-02 16:00 5966
> 08-02 17:00 1955
> 08-02 18:00 123
> 08-02 19:01 84
> 08-02 20:00 0
> 08-02 21:00 1
> 08-02 22:00 0
> 08-03 08:00 976
>
>
> All these events (99% at least) are on one table that gets inserted and selected
> from a lot.
> What are my options here??
> * increase pctfree to limit the number of rows per block is hardly an option as
> this table get quite big already and there are only 5 rows per block (8K block
> size).
>
> TIA
>
>
> Jack
>
>
>
> ===================================================================
> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
> de geadresseerde. Gebruik van deze informatie door anderen dan de
> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
> en/of verstrekking van deze informatie aan derden is niet toegestaan.
> Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ===================================================================
> The information contained in this communication is confidential and may be
> legally privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed and others authorised to receive it. If you
> are not the intended recipient you are hereby notified that any disclosure,
> copying, distribution or taking any action in reliance on the contents of
> this information is strictly prohibited and may be unlawful. Ernst &
> Young is neither liable for the proper and complete transmission of the
> information contained in this communication nor for any delay in its
> receipt.
> ===================================================================
>
>
>
> --
> Author: Jack van Zanen
> INET: nlzanen1_at_ey.nl
>
> 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
Received on Thu Aug 03 2000 - 02:21:39 CDT
