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
Avnish ,
As far as log buffer is considered , look at how much redo ur generating .
That will be help you in finding optimal size of log buffer .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 4:54 PM
What are the
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
Title: RE: Log Buffer
Yeah,
illustrioius, that's good thing isn't it? Isn't that what someone called
Lord Vador in Star Wars.noo non no, it was Jabba the hut. Ok, I take
back the illustrious, I'll think of some other large word that sounds
cool!
I
don't, it was just a question, when
yes, I think that does help. I am thinking I am going to make them larger?
21 requests
-Original Message-
Sent: Friday, March 23, 2001 2:46 PM
To: 'Kevin Kostyszyn '
Hi...
I don't think so...
you must adjust your LOG_BUFFER acoording to:
select substr(name,1,25) Name,
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.
It is very rare to a lot of a benefit once your log
buffer gets more than 512k.
hth
connor
--- Kevin Kostyszyn [EMAIL PROTECTED] wrote:
-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected against to some degree in 8i.
It is very rare to a lot
Oops,
All right, I give up, I am dumb.
Kev
-Original Message-
McDonald
Sent: Friday, March 23, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
The recommendation of 10% is very misinformed...Large
log buffers can actually hurt performance, although
this is protected
] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 14:06
To: Multiple recipients of list ORACLE-L
Subject: RE: Log Buffer
yes, I think that does help. I am thinking I am going to
make them
43 matches
Mail list logo