Re: Oracle Stats Tuning Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 22 Sep 2005 20:24:57 +0200
Message-ID: <fkt5j1hq1icrqbitr30675fnlq4f8aljbc@4ax.com>

On 22 Sep 2005 10:06:57 -0700, stockcar_at_gmail.com wrote:

>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

If 75 percent of your waits is waiting for log file sync (log file syncs happen at commit) that definitely is a problem. Either you are committing every record, or at least way to often, or LGWR can't cope. What's the value of your log_buffer parameter? It looks like you have set it too high.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Sep 22 2005 - 13:24:57 CDT