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