It is not possible to increase the number of
lgwr processes in a single instance until
9.2, and the manuals suggest that (a) you
don't do it, and (b) you only do it if you have a
very large number of CPU and massive stress
on redo generation.
Let me repeat - v$system_event can be very
First of all I'd like to have the full picture of your performance: Log
file sync might be 57% of the wait time, but how much of the response
time is wait time?
Second, Log File Sync means Commit; So if your system is waiting a lot
for commits there are two things you can do: Fewer commits
Yes, the lessons I took from that presentation were to use a shorter piece
of string and buy larger bottles of gin though I'm willing to admit that I
may have got the wrong end of the stick.
=)
Cheers,
Mike
-Original Message-
Sent: 02 January 2003 09:24
To: Multiple recipients of list
Usual caveat:
looking a v$system_event can be very misleading,
you need to examine v$session_event to determine
if anyone is actually noticing a problem.
Usual caveat 2:
A statspack report without a time interval
is almost meaningless. However, in this case,
log file
Obviously you weren't listening attentively enough.
The main thing you should have gleaned from the
presentation was that if you bash an ugly squirrel
with a hammer hard enough, then
... its still an ugly squirrel
:-)
Cheers
Connor
--- Hately, Mike (NESL-IT)
[EMAIL PROTECTED] wrote:
VIVEK_SHARMA,
Hi, can you try use raw device for those redo log files? or use
directio mode for your redo log volume.This do not need bounce your database and you
can change it on fly.
I ever hit the same problem before, and finally we modified the app to
do much
I was sensible enough to sit in the front row so I was soon distracted.
Cheers
Mike
-Original Message-
Sent: 02 January 2003 12:29
To: Multiple recipients of list ORACLE-L
Obviously you weren't listening attentively enough.
The main thing you should have gleaned from the
presentation
That was my understanding, too. Oh, and use bigger hammers, more nails and
Australian beer.
Hately, Mike (NESL-IT) wrote:
Yes, the lessons I took from that presentation were to use a shorter piece
of string and buy larger bottles of gin though I'm willing to admit that I
may have got the
REPLIES TO YOUR QUESTIONS ARE IN CAPITALS BELOW :-
THANKS
-Original Message-
Sent: Thursday, January 02, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Usual caveat:
looking a v$system_event can be very misleading,
you need to examine v$session_event to determine