Do you have any LOBs defined with
the nocache nologging attribute ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearances:
Jan 29th
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mladen Gogala
Sent: 29 January 2004 01:54
To: Multiple recipients of list ORACLE-L
Subject: Re: [Q] wait time on stat
Defaulty Windows installation usually creates log files of 20M. The
person
Hi!
Do you have any LOBs defined with
the nocache nologging attribute ?
This was what I initially thought would be the problem, but then I thought,
in case of nocache lobs you should see direct path writes (lob) a lot...
Tanel.
--
Please see the official ORACLE-L FAQ:
Mladen,
Here I will humbly disagree with you. It is not fault of Windows but the
person who created the database and defined tiny size log files while
creation. If he used custom database option he can define whatever size he
wants. These options are same for both Windows and Unix.
Regards
WE have ORACLE 9.2.0.3 database run under Win2000. I
run statspack and found Top 5 timed event. Look
like control file parallel write and redo file
parallel write take lots time. How to fix?
Top 5 Timed Events
~~
%
Increase redo logs to 250M each. You're checkpointing.
On 01/28/2004 03:09:26 PM, dba1 mcc wrote:
WE have ORACLE 9.2.0.3 database run under Win2000. I
run statspack and found Top 5 timed event. Look
like control file parallel write and redo file
parallel write take lots time. How to fix?
How did you determine the size of the logs?
Or are you just guessing that they are significantly
less than 250m?
Could just be a very busy database that needs redo
and controlfile on faster disk.
Jared
On Wed, 2004-01-28 at 12:24, Mladen Gogala wrote:
Increase redo logs to 250M each. You're
Defaulty Windows installation usually creates log files of 20M. The
person who posted the problem explicitely mentioned Windows platform.
Size of 20M is so small that the database will start to checkpoint
like crazy when you start using it for real. The number that I gave
is my rule of thumb.
Defaulty Windows installation... Hehehe;-)
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Wed 1/28/2004 8:54 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: [Q] wait time on stat
Defaulty Windows installation usually creates