Monitoring AWR report Parameters

Question

Question by Anurag S. · Mar 20, 2014 at 06:26 AM ·

Monitoring AWR report Parameters

Hi,

Can we monitor AWR report parameters in dynaTrace ?

for eg:

1) Top 5 Timed Foreground Events

2) SQL ordered by CPU Time

3) SQL ordered by User I/O Wait Time

4) Tablespace IO Stats

5) Wait Event Histogram

etc...

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2014-03-20T09:14:38Z

Answer by Nalin A. · Mar 20, 2014 at 09:14 AM

Also you can create a custom dashboard using oracle Enterprise manager, and then create web page dashlet based dashboard in dynatrace.

Regards

Nalin

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2014-03-20T08:17:47Z

Answer by Andreas G. · Mar 20, 2014 at 08:17 AM

Hi Anurag

I am not familiar with AWR - but - a quick Google Search brought me to some postings that you could query this information from specific system tables - is that correct? If so - you could use the DB Query Monitor Plugin to query that data from Oracle and bring it to dynaTrace

Andi

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Monitoring AWR report Parameters

2 Replies

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags