SLA Reporting Help
I am trying to get my 11g installation to give me accurate SLA information on database uptime. If I run the "Availability History (Target)" then I get the overall availabilty percentage which is the number I am after. But I don't want to run that report for all 30+ production databases we have.
The other option I tried was the "Availability History (Group)" which I ran for our production database group. This report seems like it gets all the information I need except for the uptime percentage....
Basically I am looking for a built in report that will give me the percentages for each production database, or a simple select statement that I can run to make my own report. Any thoughts would be appreciated.