Some useful scripts
Now is the time to see some important scripts that could help your life become a little bit easier when dealing with redo.
Redo generated since instance startup
The script redo_since_startup.sql
will show statistics regarding redo since the instance was started.
The following is an example of the output of this script:
Redo Log Statistics Statistic Statistic Name Value ---------------------------------------------- ---------- redo KB read 209048 redo KB read (memory) 0 redo KB read (memory) for transport 0 redo KB read for transport 0 redo blocks checksummed by FG (exclusive) 205974 redo blocks checksummed by LGWR 0 redo blocks read for recovery 8532 redo blocks written 367495 redo buffer allocation retries 32 redo entries 277700 ...
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.