Prev: Calculating space
Next: need help with a sql statement
From: Johne_uk on 17 Jul 2008 11:42
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
From: joel garry on 17 Jul 2008 14:19
On Jul 17, 8:42 am, Johne_uk <edg...(a)tiscali.co.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
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/autostat.htm#PFGRF02606
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/diagnsis.htm#sthref339
(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.

jg
--
@home.com 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.
Sigh.
 | 
Pages: 1
Prev: Calculating space
Next: need help with a sql statement