Monitor sessions and stats on an Oracle Active Data Guard (open read only)
Currently, if you set up an Oracle Active Data Guard database in Red Gate, it detects that it is a standby database and doesn't gather any usage, session, activity, or other data from it. However since the database is open for read, there is session data, performance data, and other metrics created that are unique to this database. Basically, the request is to monitor an Active Data Guard database as a standalone database (with the caveat that it is read only).
If Red Gate could gather those stats without requiring sysdba privileges or connection to the primary that would be a huge help.
-
Scott Lilleboe commented
This is a great idea!