Re: Fetching AWR With Exadata stats

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_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com> 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?
>>>
>>
>
>
>

--
http://www.freelists.org/webpage/oracle-l





image/png attachment: image.png