CPU and memory metrics for databases in Oracle RAC

From: trub3101 <trub3101_at_sky.com>
Date: Thu, 25 Mar 2010 06:53:35 -0700 (PDT)
Message-ID: <b42da30e-f340-43f1-a3d1-7e9301dc3eec_at_q16g2000yqq.googlegroups.com>

Hi,

I have been tasked to provide some cpu and memory metrics for the individual databases in our Oracle RAC prior to and after the installation of the third database node installed recently.

Would it be possible to extract this information from the tables in the PERFSTAT schema for each database where we have snapshots which pre-dates the install (for the first two nodes)?

If so would someone be able to tell which tables I should be using to extract this information?

Many thanks,
tb3101 Received on Thu Mar 25 2010 - 08:53:35 CDT

This message: [ Message body ]
Next message: ddf: "Re: SQL Function call does not fail on no_data_found ?"
Previous message: Mladen Gogala: "Re: ORA-19804: cannot reclaim nnnnnnnnn bytes disk space from nnnnnnnnnnnn limit"
Next in thread: Mark D Powell: "Re: CPU and memory metrics for databases in Oracle RAC"
Reply: Mark D Powell: "Re: CPU and memory metrics for databases in Oracle RAC"
Maybe reply: trub3101: "Re: CPU and memory metrics for databases in Oracle RAC"
Maybe reply: Mark D Powell: "Re: CPU and memory metrics for databases in Oracle RAC"
Maybe reply: madhu: "Re: CPU and memory metrics for databases in Oracle RAC"
Maybe reply: vsevolod afanassiev: "Re: CPU and memory metrics for databases in Oracle RAC"
Maybe reply: trub3101: "Re: CPU and memory metrics for databases in Oracle RAC"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message