Standby Database Monitoring
Hi All,
Recently we moved heavy select statements from Physical database to Standby database, as these were just reporting sql's, and also these select statements were causing huge performance issues during peak hours (reports sql run every 1 hour).
Now, since the reports are running from Physical standby database, we would like to monitor the standby database, for performance issues. Can anyone, let me know, what monitoring method you have followed.
And also, is there any chances that recovery / apply process will be delayed with heavy reports running on the standby database ?
Oracle 11.2.0.3
AIX Platform.
0