Re: Fetching AWR With Exadata stats

Thank You Ghassan.

While looking in , also see a view named "v$cell_thread_history" which has sql_d nored alongside the cell name, but seems it's not holding history more than a few minutes. So maybe as you suggested, the only way left to see longer performance history will be going for dba_hist_active_sess_history/v$active_session_history with param P1 joned on the cell_hashval column of v$cell. Correct me if wrong.

On Sun, Sep 5, 2021 at 1:47 AM Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

> Probably fron ash, the wait event params give cell hash value.
> Regards
>
> On Sat, Sep 4, 2021, 14:11 Pap <oracle.developer35_at_gmail.com> wrote:
>
>> 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