log file size
From: Orlando L <oralrnr_at_gmail.com>
Date: Mon, 16 Oct 2017 01:02:17 -0500
Message-ID: <CAL8Ae75kdVFGaabzXemEk=5VGBSy+r+k-sFz10L50j1QQBP9NQ_at_mail.gmail.com>
Hello,
Date: Mon, 16 Oct 2017 01:02:17 -0500
Message-ID: <CAL8Ae75kdVFGaabzXemEk=5VGBSy+r+k-sFz10L50j1QQBP9NQ_at_mail.gmail.com>
Hello,
I recently inherited a prod DB; one of the things I noticed was that it was
doing log switches around 15 times a minute (not one hour). I did some
calculation based on the log sizes and I came up with a size of 4 Gb per
log for less frequent switches. Is there any limitations fellow oraclites
can think of in setting the online log files high. One thing I can think of
archiver delay locally and standby lag, if any, in case if the switches
slow down.
Orlando.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 16 2017 - 08:02:17 CEST