Redo & Archive Logs
How to check log switches per hour for the last 7 days in Oracle
Pivot Oracle log switches by hour across every day for the last 7 days, per RAC instance, from GV$LOG_HISTORY.
How to check archived redo volume by hour in Oracle
Show archived redo size (GB) per hour for a specific day in Oracle from V$ARCHIVED_LOG.
How to check archived redo volume by day in Oracle
Show total archived redo size (GB) per day for the last N days in Oracle from V$ARCHIVED_LOG.
How to calculate the recommended online redo log size in Oracle
Estimate the ideal Oracle online redo log size from the average log switch period during peak hours over the last 3 days.
How to check daily redo generation in Oracle
Show Oracle log switches and archived redo size (MB) per day from V$ARCHIVED_LOG for capacity planning.
How to check online redo log groups in Oracle
List online redo log groups with member paths, thread, archived flag, status, and size in MB.
How to check hourly log switches by day in Oracle
Pivot Oracle log switch counts across 24 hourly columns for every day recorded in V$LOG_HISTORY.
How to check archived redo volume by minute in Oracle
Show archived redo size (MB) per minute in Oracle for the last N minutes from V$ARCHIVED_LOG.
How to check archive log and redo log status in Oracle
Check Oracle redo logfiles and groups, the last archived sequence, hourly archive generation, and the archive interval.
How to check archive log generation per hour in Oracle
Check Oracle archive log generation per hour: volume in GB and count, per thread.
How to check archive log generation per day in Oracle
Check Oracle archive log generation per day: volume in GB and count, per thread.