Re: How to graph multi-series time-based SQL output?
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 27 Apr 2011 11:57:17 -0500 (CDT)
Message-ID: <75c43e417e77f8e4abf05a1e1b97f680.squirrel_at_society.servebeer.com>
As a followup, I received four responses advocating a wide range of ideas. I evaluated them all, which led me to integrating Open Flash Chart 2 into APEX via PHP. My primary limitation I discovered is that I'm currently stuck with the ancient PHP4 that comes with OracleAS 10.x (and upgrading to v11 looks daunting!).
Date: Wed, 27 Apr 2011 11:57:17 -0500 (CDT)
Message-ID: <75c43e417e77f8e4abf05a1e1b97f680.squirrel_at_society.servebeer.com>
As a followup, I received four responses advocating a wide range of ideas. I evaluated them all, which led me to integrating Open Flash Chart 2 into APEX via PHP. My primary limitation I discovered is that I'm currently stuck with the ancient PHP4 that comes with OracleAS 10.x (and upgrading to v11 looks daunting!).
My very busy graph of Buffer Cache contents over time becomes very usable with the handy tool tips in OFC2. And with a little JQuery UI, it's even dynamically resizable.
Thanks all for the feedback! It pointed me in the right direction for the best solution.
Rich
> Hey all,
>
> I have a Grid Control report containing a graph of:
...
> Anyone have a way to generate a single multiple-series time-based graph
> based on *DYNAMIC* SQL output? I've been looking at gnuplot, rrdtool, mrtg,
> and the like, but the *DYNAMIC* part eludes me.
>
> I'm open to most ideas, but my preference would be something that I could
> hook into Apache/PHP, as a web-based solution would probably work better
> over a slow VPN.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 27 2011 - 11:57:17 CDT