Re: Database Reporting Input/Suggestions Needed

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: toon.koppelaars@xxxxxxxxxxx
  • Date: Mon, 23 Mar 2009 17:45:37 +0000

oops didn't see Toon recommending APEX.

Me I'd give them the URL and also consider generating some xml publisher
stuff on a schedule with them as mail recips.

Niall

2009/3/23 Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>

> 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@xxxxxxxxxxxxxxx> 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).
>>
>> Thoughts/Ideas?
>>
>>
>>
>>
>> *Chris Taylor*
>> *Sr. Oracle DBA*
>> Ingram Barge Company
>> Nashville, TN 37205
>> Office: 615-517-3355
>> Cell: 615-354-4799
>> Email: chris.taylor@xxxxxxxxxxxxxxx
>>
>>
>
>
>
> --
> Toon Koppelaars
> RuleGen BV
> +31-615907269
> Toon.Koppelaars@xxxxxxxxxxx
> www.RuleGen.com <http://www.rulegen.com/>
> thehelsinkideclaration.blogspot.com
>
> (co)Author: "Applied Mathematics for Database Professionals"
> www.RuleGen.com/pls/apex/f?p=14265:13<http://www.rulegen.com/pls/apex/f?p=14265:13>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: