Re: Database reports for management

From: Hans Forbrich <>
Date: Thu, 11 Jun 2015 17:35:51 -0600
Message-ID: <>

On 11/06/2015 10:13 AM, Manjula Krishnan wrote:
> Management is requesting weekly database reports. What kind of reports
> can I provide without being too technical? What tools/scripts do you use?

Find out WHY they want the reports. If they can not tell you, assume it is because they want justification for your job, at which point they want:

  • how many instances; how many instances added/wiped this week;
  • how many applications (and owners)
  • how many users; change in user count; time used to do that;
  • how many backups, restores, flashbacks or partial recoveries; time involved
  • how many outages; time involved and brief summary how resolved;
  • how many performance issues; time involved and approach to resolve

In most cases, technical stuff from the AWR is of limited interest although it does make for good pictures.

All of the above can be obtained through OEM CC


Received on Fri Jun 12 2015 - 01:35:51 CEST

Original text of this message