automate and print out awr report

msimons4
msimons4 used Ask the Experts™
on
Is their a script to automate and print out the results from an awr report?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I've never tried.  Automation looks simple enough.  Not sure about printing.

Looks like you can run it from internal packages:  DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML

Even though it doesn't appear there is a 100% final solution here check out:
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23684784.html

Author

Commented:
I tried this script and had a couple of problems such as you cannot use an order by clause in an nested query.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I mentioned it wasn't 100%...

Unfortunately I don't have a system where I can get this script working.

Until another Expert shows up that might be able to take that code and get it working, I suggest you start looking through the docs for DBMS_WORKLOAD_REPOSITORY to see what options are available.

Author

Commented:
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
I don't have time right now to walk through the code line by line and am still unable to just run it.

It doesn't look like it's doing anything overly bad.

you might look at the logic for getting the snapshot ids.  Looks like that script is going for a specific hour's snapshot then the one 8 hours before.

...
-- get end snapshot id (the latest 20hr snapshot)
...
-- get start snapshot id (the latest 8hr snapshot before the latest 20hr snapshot)
...

Author

Commented:
Thanks

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial