ToolPlan capacity

Redo log sizing

Pick a redo log size that keeps log switches to a steady rhythm at your busiest hour, then get the statements to add the new groups, the matching standby redo logs, and drop the old ones.

Open the tool

The tool runs entirely in your browser. Nothing you type into it is sent anywhere.

Related scripts

• Redo generated per hourActual redo volume per hour for the last 7 days, from archived log sizes on the local destination, so early log switches and Data Guard copies don't…
• Log switches per hour, last 7 daysA day-by-hour grid of log switches. Aim for roughly four an hour at peak; consistently more means the redo logs are too small.
• Online redo log groups and membersEvery redo log group with its thread, sequence, archived flag, status, member file and size. More than one CURRENT per thread, or members missing…
• Standby redo log configurationStandby redo logs by thread. You want one more group per thread than you have online log groups, all the same size as the online logs.