Aw: Database Reports to Upper Management
Date: Mon, 3 Feb 2014 17:51:22 +0100 (CET)
Message-ID: <trinity-10f0bc55-f7f7-4e5f-9227-9391da7292c6-1391446282019_at_3capp-gmx-bs49>
Hi,
For management:
Not too much.
Yearly: Number of databases hosted / administered. Number of changes we were involved in. Basically bragging about the amount of work we do.
Monthly: reports about tnsping or connection times for each database (too high may count as outage for
SLA purposes)
For ourselves:
Daily: space statistics (datafiles / archivelogs, ...) per database and harddisk (local / storage system)
Gives us 8 years of growth data.
Daily: time since last successful backup / archivelog backup, maximum age of undeleted archivelogs
Daily: restarts in the last 24 hours. (Catches very short outages).
Monthly: number of successful / failed backups
Monthly: reports about cmdb changes and "suspicious" contents - helps to keep data quality within cmdb.
(We also run these for some non-database cmdb contents for other teams.)
Everything else is mostly technical and run on a "want to know"-basis and not regularly.
Regards
Ingrid
-
Gesendet: Montag, 03. Februar 2014 um 17:31 Uhr Von: "Jeff C" <backseatdba_at_gmail.com> An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Betreff: Database Reports to Upper Management
What are some of the reports that you generate for your upper management on a weekly, monthly, etc basis? What do use to generate these reports? Manually put data in Excel or use Enterprise Manager? My management has requested reports but they don't know what they want so I am trying to figure out what would be useful.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 03 2014 - 17:51:22 CET