Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Log Buffer in SGA <---> Online redo files

Log Buffer in SGA <---> Online redo files

From: Jonathan E Miller <jmiller_at_fnol.net>
Date: Mon, 22 Nov 1999 20:27:48 -0500
Message-ID: <s3jrjenv3ef23@corp.supernews.com>


I'm about to create a new database (my first real production one) and was wondering whether there are recommended sizing relationships between the log buffer in SGA and the redo files on disk. I've set the redo files to 5M and there are 3 mirrored groups of them and I've set the log buffer to 500K. Will this work? ANd I mean will it work efficiently? The DBA guides dont have much in the way of log buffer sizing recommendations. Thanks very much -

Jonathan Received on Mon Nov 22 1999 - 19:27:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US