Re: Fetching AWR With Exadata stats

From: Pap <oracle.developer35@xxxxxxxxx>
To: Anton Spitsyn <antonio.spitsyn@xxxxxxxxx>, salem.ghassan@xxxxxxxxx
Date: Sat, 4 Sep 2021 17:40:49 +0530

Thank You So much Anton and Ghassan. That helps a lot. So basically I can
either fetch the AWR from the 19C database and look into the Exadata
statistics section which will be the same for all the databases in that
exadata machine as storage cell nodes are shared across even compute
nodes/DB nodes are different. Correct me if I'm wrong.

Another point I see, while going through the DBA_HISt* views mentioned in
the posted URL by Anton , I see none of them hold sql_id information on
them, but in the OEM exadata perforame page I can see top sql by CPU
against each cell node. So I wanted to understand if there is any DBA_HIST*
view which relates the top resources like CPU/IO on a cell node directly to
the sql_id and we can manually fetch that information for historical
performance analysis?

[image: image.png]

On Fri, Sep 3, 2021 at 5:28 PM Anton Spitsyn <antonio.spitsyn@xxxxxxxxx>
wrote:

Hi Pap,

Exadata related stats stored in the Automatic Workload Repository (AWR)
views, which contain information that is specific to Oracle Exadata
Database Machine

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-db-dictionary-views.html#GUID-C7AA7FF7-EEAF-4F7D-9D22-01FE7516F7D4

Tanel Poder did a presentation Exadata Performance: Latest Improvements
and Less Known Features, which mentioned Monitoring Improvements for
Exadata since Oracle 12c

--
Anton Spitsyn
Database Administrator
http://aspitsyn.wordpress.com

On Fri, Sep 3, 2021 at 1:03 PM Pap <oracle.developer35@xxxxxxxxx> wrote:

Is it really true that there is no possible way to see the exadata cell
node stats in AWR for a 11.2.0.4 version database?

On Fri, Sep 3, 2021 at 1:02 AM Pap <oracle.developer35@xxxxxxxxx> wrote:

Hi All, we are having a database with version 11.2.0.4 and we want to
see EXADATA related stats in it but that section is not available in it
when we fetch it from the OEM.
I heard/read somewhere in the past that , if any database is available
in the same box with 12C+ version then also we will be able to see the
Exadata stats section in the fetched AWR even if it's for a 11.2 version
database. And we do have databases with version 19C in the same
exadata machine. So I want to understand , how can I fetch the AWR from the
OEM so that the EXADATA related stats will be visible for this 11.2
database in the AWR report?

References:
- Fetching AWR With Exadata stats
  - From: Pap
- Re: Fetching AWR With Exadata stats
  - From: Pap
- Re: Fetching AWR With Exadata stats
  - From: Anton Spitsyn

Re: Fetching AWR With Exadata stats

Other related posts: