Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data_block waits how to solve

RE: Data_block waits how to solve

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Tue, 8 Aug 2000 18:30:08 -0300
Message-Id: <10583.114127@fatcity.com>


Hi:

    Please correct me if I'm wrong, but I think your options are:

Hope it helps

-----Mensaje original-----
De: Jack van Zanen <nlzanen1_at_ey.nl>
Para: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Fecha: Jueves 3 de Agosto de 2000 3:44 AM Asunto: 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 Tue Aug 08 2000 - 16:30:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US