Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: log buffer space
Are there any equations which can say log buffer is small or large ? I mean how to find the proper size of log buffer .
-ak
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.
-----Original Message-----
From: oramagic_at_hotmail.com [mailto:oramagic_at_hotmail.com]
Sent: Thursday, March 13, 2003 4:49 PM
To: Multiple recipients of list ORACLE-L
Subject: log buffer space
I am finding tons of "log buffer space" waits in 10046 output . Does it necessarily means I should look for resizing log_buffer ? What else can be done or looked at to reduce these waits .
Thanks,
ak
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: AK
INET: oramagic_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 14 2003 - 10:14:07 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message