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

Home -> Community -> Usenet -> c.d.o.server -> Oracle Stats Tuning Question

Oracle Stats Tuning Question

From: <stockcar_at_gmail.com>
Date: 22 Sep 2005 10:06:57 -0700
Message-ID: <1127408817.386343.113060@g14g2000cwa.googlegroups.com>


Could someone comment on these figures from our Oracle 8.1.7 database? I don't know what is acceptable or if this needs some tuning?

Thank you in advance.

log file sync            1,236,225    2,135,472    75.54
latch free                 843,822    240,455      8.51
db file sequential read    307,571    164,172      5.81
log file parallel write    922,302    117,881      4.17
buffer busy waits          40,700     113,049      4.00
Received on Thu Sep 22 2005 - 12:06:57 CDT

Original text of this message

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