Tuning 8i Help Plz!!!

From: Aakash <daakash_at_yahoo.com>
Date: 17 Mar 2004 04:23:17 -0800
Message-ID: <83fd0b82.0403170423.24bf3a57@posting.google.com>

hi gurus,

on running the query

SELECT event,
sum(total_waits ) total_waits,
sum(total_timeouts ) total_timeouts
FROM v$system_event
group by event ;

i get the results as follows , any tips on tuning by seeing these output? the DB is up and running for 25 days 24/7. any tips would be appreciated.

Thanks.

EVENT                     TOTAL_WAITS TOTAL_TIMEOUTS
------------------------- ----------- --------------
DFS lock handle               3030585          29755
LGWR wait for redo copy         25172            140
LMON wait for LMD to inhe           1              1

rit communication channel
s

Null event                          3              3
PX Deq Credit: need buffe      337824            780

r

PX Deq Credit: send blkd      4079108         195504
PX Deq: Execute Reply          818362          26765
PX Deq: Execution Msg         2221644         379152
PX Deq: Join ACK               141496              8
PX Deq: Msg Fragment             4010             92
PX Deq: Parse Reply            168083             58
PX Deq: Signal ACK              70933          62756
PX Deq: Table Q Get Keys           70              0
PX Deq: Table Q Normal        9896041           9832
PX Deq: Table Q Sample          64137            113
PX Deq: Table Q qref            49892              1
PX Deq: Txn Recovery Star        1030           1018

t

PX Idle Wait                  2152129        2005756
PX qref latch                    2646           2154
SQL*Net break/reset to cl       12820              0

ient

SQL*Net break/reset to db 101 0 link

SQL*Net message from clie 144403959 0 nt

SQL*Net message from dbli 70537 0 nk

SQL*Net message to client   144404180              0
SQL*Net message to dblink       70537              0
SQL*Net more data from cl       29535              0

ient

SQL*Net more data from db 209 0 link

SQL*Net more data to clie 34308857 0 nt

Wait for stopper event to 3279 3279  be increased

buffer busy due to global 283153 406  cache

buffer busy waits              270462            125
buffer deadlock                     3              3
control file parallel wri      726265              0

te

control file sequential r 130807 0 ead

db file parallel read            7521              0
db file parallel write         317829              0
db file scattered read       13542608              0
db file sequential read      54011094              0
direct path read             48257173              0
direct path read (lob)              1              0
direct path write             5217444              0
direct path write (lob)             4              0
enqueue                       2157182          83955
file identify                   13385              0
file open                      577499              0
global cache bg acks                2              0
global cache cr request      78887772          82032
global cache lock busy          73386             58
global cache lock null to        9461            128

 s

global cache lock null to 17122 374  x

global cache lock open s       203191            117
global cache lock open x       494631            304
global cache lock s to x      1251575             99
instance state change               1              0
latch free                   58928005        4005146
library cache load lock           432             29
library cache lock            1070014           3884
library cache pin              326817            437
local write wait                 1712              1
lock manager wait for rem   517111857       18894451

ote message

log buffer space                 4982             23
log file parallel write       1329685              8
log file sequential read      1062235              0
log file single write            6656              0
log file switch (archivin        1302           1224

g needed)

log file switch completio 1745 126 n

log file sync                  269929            314
name-service call wait           4709            272
pipe get                        13115            860
pmon timer                     800509         669395
process startup                  2250             37
rdbms ipc message           112508938       92640616
rdbms ipc reply                926382            789
refresh controlfile comma        3109              0

nd

row cache lock                3639192              3
single-task message                 6              0
smon timer                       7206           6806
sort segment request                1              1
switch logfile command             19              0
transaction                       797            797
undo segment extension         756896         756879
wait for LMON to get to F        4090              5

TDONE

wait for gms registration          47             47
wait for inquiry response      218265            216
wait for lock db to becom           3              3

e frozen

wait for lock db to unfre 1 1 eze Received on Wed Mar 17 2004 - 06:23:17 CST