<div>
I've never tried. &nbsp;Automation looks simple enough. &nbsp;Not sure about printing.<br />
<br />
Looks like you can run it from internal packages: &nbsp;DBMS_WORKLOAD_REPOSITORY.A<wbr />WR_REPORT_<wbr />HTML<br />
<br />
Even though it doesn't appear there is a 100% final solution here check out:<br />
<a href="https://www.experts-exchange.com/questions/23684784/How-to-automate-AWR-reports-through-Oracle-create-program-and-scheduler.html" rel="ugc">https://www.experts-exchange.com/questions/23684784/How-to-automate-AWR-reports-through-Oracle-create-program-and-scheduler.html</a>
</div>


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:
https://www.experts-exchange.com/questions/23684784/How-to-automate-AWR-reports-through-Oracle-create-program-and-scheduler.html [https://www.experts-exchange.com/questions/23684784/How-to-automate-AWR-reports-through-Oracle-create-program-and-scheduler.html]

<div>
I tried this script and had a couple of problems such as you cannot use an order by clause in an nested query.
</div>


I tried this script and had a couple of problems such as you cannot use an order by clause in an nested query.

<div>
I mentioned it wasn't 100%...<br />
<br />
Unfortunately I don't have a system where I can get this script working.<br />
<br />
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.
</div>


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.

<div>
I just found this, do you think it might work?<br />
<a href="http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=35626#125969" rel="ugc">http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=35626#125969</a><br />
<br />

</div>


I just found this, do you think it might work?
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=35626#125969 [http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=35626#125969]



<div>
<div class="content wysiwyg-content">
Is their a script to automate and print out the results from an awr report?
</div>
</div>


Is their a script to automate and print out the results from an awr report?

automate and print out awr report

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.