Re: Database Reporting Input/Suggestions Needed
Date: Mon, 23 Mar 2009 16:01:14 +0100
I'd use Apex for that.
Build your views in the database, then generate an Apex graph report on top of the view.
Email your managers the Apex url straight to the page that has the graph report.
On Mon, Mar 23, 2009 at 3:48 PM, Taylor, Chris David < Chris.Taylor_at_ingrambarge.com> wrote:
> I have a need to develop some database reports that are mailed out at
> regular intervals for management. These reports need to be geared more to a
> management position with 'eye candy' - you know, charts, graphs, pretty
> colors. ;)
> Anyway, I was looking at Grid Control 10.2.0.4 which we have and wasn't
> really satisfied with the reporting functionality from that point of view.
> I want to capture metrics such as CPU Usage, disk space usage/growth,
> concurrent users and disk space used by backups (more of a physical
> server specific report).
> So, I need some suggestions from people who have this type of reporting
> setup. What product or custom solution did you use? What metrics are you
> capturing? I'm just getting started down this road and am looking for ideas
> and possible solutions.
> I'm not much of a developer - I can do some PL/SQL and maybe a little
> VB.Net (with some help from our developers).
> *Chris Taylor*
> *Sr. Oracle DBA*
> Ingram Barge Company
> Nashville, TN 37205
> Office: 615-517-3355
> Cell: 615-354-4799
> Email: chris.taylor_at_ingrambarge.com
-- Toon Koppelaars RuleGen BV +31-615907269 Toon.Koppelaars_at_RuleGen.com www.RuleGen.com thehelsinkideclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 23 2009 - 10:01:14 CDT