<div>
To find the min/max ids for yesterday try this:<br />
<br />
SELECT MIN(snap_id) minid, MAX(snap_id) maxid<br />
&nbsp; FROM dba_hist_snapshot<br />
&nbsp;WHERE begin_interval_time &gt;= TRUNC(SYSDATE) - 1 AND end_interval_time &lt;&nbsp;TRUNC(SYSDATE)
</div>


To find the min/max ids for yesterday try this:

SELECT MIN(snap_id) minid, MAX(snap_id) maxid
  FROM dba_hist_snapshot
 WHERE begin_interval_time >= TRUNC(SYSDATE) - 1 AND end_interval_time < TRUNC(SYSDATE)

<div>
ok - but how do I script this to run the awr and addm report - how do you get those values into<br />
@awr<br />
and<br />
@addm
</div>


ok - but how do I script this to run the awr and addm report - how do you get those values into
@awr
and
@addm

<div>
is there a way to make this html?
</div>


<div>
change<br />
<br />
awr_report_text<br />
<br />
to<br />
<br />
awr_report_html
</div>


change

awr_report_text

to

awr_report_html

<div>
great ! :)<br />
thanks much
</div>


<div>
<div class="content wysiwyg-content">
is there a way to automate the awr and addm reports - I want to run them every day for a period of one day - how do you find the right start/end numbers? &nbsp;I need this to fit into a script I can put in cron.<br />
<br />
oracle 11g aix 6<br />
<br />
thanks
</div>
</div>


is there a way to automate the awr and addm reports - I want to run them every day for a period of one day - how do you find the right start/end numbers?  I need this to fit into a script I can put in cron.

oracle 11g aix 6

thanks

oracle awr &amp; addm reports - automate

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.

Oracle Database

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.

oracle awr &amp; addm reports - automate

oracle awr & addm reports - automate