Re: 10G Grid Control - Extracting Metric Data

From: joel garry <>
Date: Thu, 17 Jul 2008 11:19:19 -0700 (PDT)
Message-ID: <>

On Jul 17, 8:42 am, Johne_uk <> wrote:
> Hi,
> I've recently installed Oracle Grid control 10G to monitor a number of
> db instances which is working well.
> My manager is currently setting up a system that will include various
> Key Performance Inidcators for oracle based systems e.g. uptime etc.
> He's requesting whether I can provide the raw data for these metrics
> in a spreadsheet so he can manipulate the data himself. I've looked at
> the standard reports in Grid and everything seems to be geared towards
> on-screen graphs etc.
> I'm not overly enthused about using sql directly to interrogate the
> apps dba itself, so wondering if anywbody has come across any other
> means to extract metric data directly in tabular form.
> Thanks in anticipation
> John

Stuff like this may be found in the manuals, for example (note the views!)

Poking around in the $ORACLE_HOME/rdbms/admin directory can be educational, too. I haven't looked at using EM to look at what EM is doing, but I bet you can do that.

sqlplus makes it easy to set the separator to a comma.

But I think the pictures in EM are pretty.


-- is bogus.
And of course, I was running EM under firefox on hp-ux accessed via
reflection X on XP, and it encountered a problem and needed to close.
Received on Thu Jul 17 2008 - 13:19:19 CDT

Original text of this message