Re: making graphical reports from oracle metrics

Why don't you try using Oracle's Application Express? I've used it in the past and it works very well.

   Peter

On Mon, Dec 1, 2008 at 3:29 PM, Rich Jesse <rjoralist_at_society.servebeer.com>wrote:

> I have a simple query that reports user tables sorted descending by size.
> I
> had been dumping this into MS Exxhell every Monday, then going through the
> gyrations of creating the graph to print out and hang on my wall for
> passers
> by (especially management) to see. The problems with this approach are
> that
> it's time-consuming and the MS Exxhell graph generation is difficult for me
> to create consistently (fonts, size, layout, etc). This made for a
> less-than-professional look as I showed folks the graph history.
>
> What I ended up doing is using Quest's Toad to create a saved FastReport
> for
> my query. Now when I run the query via Toad, I can very easily generate a
> consistent bar graph of just my top 20 tables with an additional bitbucket
> column to sum the sizes of the next 30 tables without modifying the SQL --
> it's literally two mouse clicks. Additionally, I could schedule this to
> run
> automagically every Monday at 6:30 AM to be waiting for me when I get in.
> Unfortunately, the portability of my laptop prevents me from using this
> feature, but it might work well in your environment.
>
> As I've been using commercial Toad since it's inception, I'm not as
> familiar
> with the free version of Toad, but it might be worth a look for you if the
> (wonderful) commercial version isn't viable. Also, a FastReports FAQ for
> Toad can be found here:
>
> http://asktoad.com/DWiki/doku.php/faq/questions#fastreports
>
> Of course, I have the huge disclaimer that I'm a Toad bigot and have been
> for over 10 years. :)
>
> Toad for Oracle: http://www.quest.com
> Toad Freeware: http://www.toadsoft.com/lic_agree.html
>
> HTH! GL!
>
> Rich
>
>
> > I take no credit for this. I read this at Howard Rodgers site
> > www.dizwell.com a long time ago. I've tested it and had better success
> > with 64-bit distros. For some reason, my lines got wrapped before I
> > wanted them to with the 32-bit distros and XML is picky. If you have
> > 10g (and presumably 11g), this should work to produce an XML and then
> > you can open it with Excel. I know this won't produce the graphics but
> > might provide an easier way to get it into Excel.
> >
> > set long 100000
> > set pagesize 400
> > select dbms_xmlgen.getxml('select * from emp') from dual;
> >
> > Kevin
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Peter Steinheuser
EnterpriseDB Corporation
499 Thornall Street
2nd Floor
Edison, NJ 08837
+1.732.331.1378 Office
+1.908.419.4220 Cell
+1.732.331.1301 Fax
peter.steinheuser_at_enterprisedb.com

http://www.enterprisedb.com
Built on open source. Compatible with Oracle(R).

--
http://www.freelists.org/webpage/oracle-l