Vivek - When you've got Cary Millsap quoting Steve Adams, well the advice
just doesn't get any better than that. Go with their advice. As I pointed
out, I replied because at that point nobody had posted yet.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
These are cumalitive times for a few hundred processes.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/03/2003 10:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: log buffer space wait
I have
I have
one question regarding these wait times, may be dump.In the following wait
events what is the unit of measurement for Time, I believe its in seconds as per
the documentation. If yes thenhere stats
are collectedfor only 51.23 Minutes (Appx 3073 seconds), how come
Oracle is showing
AMTo:
Multiple recipients of list ORACLE-LSubject: Re: log buffer space
wait
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you
Vivek
Good question. At this point I haven't seen any replies to your request.
The specific wait points to the log buffer itself as being too small, not
particularly the redo logs themselves. Your init.ora parameters show this
buffer as being only 10-meg. I would suggest you increase it. But
http://www.ixora.com.au/q+a/0008/24162020.htm
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
DENNIS WILLIAMS
Sent:
Hi!
What's the value for _log_simultaneous_copies
parameter? You might want to manually increase it, even though it depends on
CPU_COUNT when left default.
I personally would increase log_buffer size as
well, if you got that many CPUs and concurrent sessions.
Tanel.
- Original
Jared
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/02/2003 08:24 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: log buffer space wait
Hi!
What's the value for _log_simultaneous_copies
I've just tried a different test, along the following
lines, which seems to confirm that LGWR is
triggered when the buffer is about 1/3 full.
Set log_buffer to an easy number such as 600K.
Create table with one column of a nice large size,
e.g. varchar2(1000);
Take snapshot of redo size, redo
Jonathan:
I have just sent a mail which has the test statistics.
I would appreciate your comments on that..
Alternatively, people who are curious may want to
test the log writer writing habits using the
event 10046^8.
KG
Best Regards,
K Gopalakrishnan
-Original Message-
Lewis
KG,
I got the direct mail much quicker than the
list mail - but I'll just echo the doubt I raised
in the original.
If you use 10046 level 8 to watch for log writer
writes, I would expect you to see writes that
could be of an almost arbitrary size.
Assume a 3MB log buffer - we 'know' that
a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small
and 3.
As Kirti suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing
suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk) to other
not-so-busy disks.
- Kirti
=
Have a nice day
, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing
: log buffer space
Increasing log_buffer size is an option, if it is really small.
I
would also check if the redo logs are on a busy disk. If so, try moving those
(or other busy data fileson the same disk) to othernot-so-busy
disks.
-
Kirti
-Original Message
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk) to other
not-so-busy
: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk) to other
not-so-busy disks.
- Kirti
=
Have a nice day
of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk
Title: RE: log buffer space
I think this might help...
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: log
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy data files on the same disk) to other
not-so
: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so,
try moving those
.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check
suggested, the problem could be due to the redo logs
being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
be due to the redo logs
being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
It's easy to
check #s 4 and 3.
As Kirti suggested, the problem could be due to the redo logs being
on a busy disk, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: l
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so,
try
moving those
recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I would also check if the redo logs are on a busy disk. If so, try
moving those (or other busy
, or even a slow one.
HTH.
Arup
- Original Message -
From: Deshpande, Kirti
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 13, 2003 8:13 PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I
Increasing log_buffer size is an option, if it is really small.
I
would also check if the redo logs are on a busy disk. If so, try moving those
(or other busy data fileson the same disk) to othernot-so-busy
disks.
-
Kirti
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Sent: Thursday, March 13, 2003 8:13
PM
Subject: RE: log buffer space
Increasing log_buffer size is an option, if it is really small.
I
would also check if the redo logs are on a busy disk. If so, try moving those
(or other busy data fileson the same disk) to othernot-so-busy
36 matches
Mail list logo