Wait events

From: <fly13_at_my-deja.com>
Date: Thu, 12 Oct 2000 09:50:38 GMT
Message-ID: <8s41hd$2fg$1@nnrp1.deja.com>

hi girls and boys,
I use the statspack of oracle to tune my database, and i can see in the table concerning waiting events :

                                                            Avg
                                                 Total Wait  wait  Waits
Event                           Waits   Timeouts  Time (cs) (ms)   /txn
------------------------ ------------ ---------- --------- ----- ------
control file sequential read       33          0         6     2   33.0
control file parallel write        50          0         4     1   50.0
refresh controlfile command         5          0         2     4    5.0
direct path read                  832          0         1     0  832.0
direct path write                 644          0         0     0  644.0
log file parallel write             9          0         0     0    9.0
SQL*Net break/reset to clien        4          0         0     0    4.0
file open                           4          0         0     0    4.0
LGWR wait for redo copy             1          0         0     0    1.0
log file sync                       1          0         0     0    1.0
SQL*Net message from client        84          0     3,042   362   84.0
SQL*Net message to client          84          0         0     0   84.0


         -------------------------------------------------------------

Background Wait Events for DB: DBTEST Instance: dbtest Snaps: 1 -

                                                             Avg
                                                Total Wait   wait  Waits
Event                           Waits Timeouts  Time (cs)   (ms)  /txn
------------------------ ------------ -------- ----------- ----- ------
control file parallel write        50          0         4     1   50.0
control file sequential read       15          0         2     1   15.0
log file parallel write             8          0         0     0    8.0
LGWR wait for redo copy             1          0         0     0    1.0
rdbms ipc message                 171        150     8,514   498  171.0
pmon timer                         50         50     2,764   553   50.0


         -------------------------------------------------------------

SQL ordered by Gets for DB: DBTEST Instance: dbtest Snaps: 1 - 2

So i would like to know if anybody can tell what i could to do to decrease waiting times.

Thanks

See you

Fly13

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 12 2000 - 04:50:38 CDT