V$MANAGED_STANDBY -- lgwr, rfs, lns, arch, mrp information
V$ARCHIVED_LOG -- logs received by standby
V$LOG_HISTORY -- archive history details
V$DATAGUARD_STATUS -- dataguard messages/errors written to alert log and/or trace files
V$RECOVERY_PROGRESS -- recovery information
V$STANDBY_EVENT_HISTOGRAM -- log applying lag histogram
DBA_LOGSTDBY_LOG -- applied log information
DBA_LOGSTDBY_EVENTS -- log applied events in alert log
V$LOGSTDBY_PROCESS -- log apply processes current status
Subscribe to:
Post Comments (Atom)
My own Mind Map program in Java script and Python
I had been searching online mindmap apps for my study for a while and never got one that I am really happy with. Then I asked myself what I...
-
During performance tuning or being called to debug a performance issues of the database system, we always would like to know the current I/O...
-
There is a bug in 11.2.0.2 and 11.2.0.3 that causes worse plan. need to add hint /*+OPT_PARAM('_optimizer_use_feedback','false...
-
This script shows you information about your memory configurations, current usage, adviser views, etc. Before jumping into any conclusions, ...
No comments:
Post a Comment