Archived redo log size difference in 10gR2

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Tue, 31 Oct 2006 13:49:01 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A52453@QTEX1.qg.com>

Hey all,

We're well on our way to implementing a new ERP system in 10.2.0.2.0 on AIX 5.3. One thing I've noticed is that while the redo logs are ~50MB, the archived redo logs from "regular" log switches are consistently only ~45MB. On 9.2.0.5 on HPUX, our 90MB redos tend to switch with 2K free.

Not that this affects a whole lot in my planning, but I'm just curious. Trapsing through the admin docs doesn't seem to mention anything other than the minimum size of a log is 4MB.

Thoughts anyone? And if you have definitive info, where from?

TIA,
Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 31 2006 - 13:49:01 CST