Monitor steps for Logical Standby Database
1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when diagnosing performance problems during the logical application of archived redo logs to the standby database, and it can be helpful for other problems. This view is for logical standby databases only. INPUT QUERY:- SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE […]