MIME-Version: 1.0
In-Reply-To: <3c5f7821003031254i103c63axb26646c6311d42b9@mail.gmail.com>
References: <3c5f7821003031254i103c63axb26646c6311d42b9@mail.gmail.com>
Date: Wed, 3 Mar 2010 16:02:52 -0600
Message-ID: <bc04324b1003031402p1ad81379lb85fc23532419678@mail.gmail.com>
Subject: Re: Script to automate AWR reports (not snapshots)
From: Dan Norris <dannorris@dannorris.com>
To: sbecker6925@gmail.com
Cc: oracle-l <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=000e0cd70b34d57d5f0480eca44b
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: dannorris@dannorris.com
--000e0cd70b34d57d5f0480eca44b
Content-Type: text/plain; charset=ISO-8859-1

Read the comments in the top of the $OH/rdbms/admin/awrrpti.sql script. It
tells you exactly how to set the proper variables so that you can call it
without prompting. From there, you can automate it as needed.

I've used this method to run AWR reports for each instance of a RAC
environment from a single location (instead of having to login to each
instance) because instance id is a variable you can pass in.

Dan

On Wed, Mar 3, 2010 at 2:54 PM, Sandra Becker <sbecker6925@gmail.com> wrote:

> Platform:  IBM z9
> OS:  SUSE10
> Oracle:  10gR2
>
> Management is under the mistaken impression that the performance problems
> we are experiencing on a daily basis ALWAYS happen at the same time.  To
> that end, they want me to set up a shell script that will run an AWR report
> daily for each of the two time periods they believe the problems are
> occuring.  I haven't been able to convince them we should run reports for
> the times we KNOW we had problems.  I also haven't been able to locate a
> script to automatically run reports for the specific time periods--I'm
> probably not entering the right search criteria.  Does anyone have such a
> script or can point me in the right direction?
>
> --
> Sandy
> Transzap, Inc.
>

--000e0cd70b34d57d5f0480eca44b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Read the comments in the top of the $OH/rdbms/admin/awrrpti.sql script. It =
tells you exactly how to set the proper variables so that you can call it w=
ithout prompting. From there, you can automate it as needed.<br><br>I&#39;v=
e used this method to run AWR reports for each instance of a RAC environmen=
t from a single location (instead of having to login to each instance) beca=
use instance id is a variable you can pass in.<br>
<br>Dan<br><br><div class=3D"gmail_quote">On Wed, Mar 3, 2010 at 2:54 PM, S=
andra Becker <span dir=3D"ltr">&lt;<a href=3D"mailto:sbecker6925@gmail.com"=
>sbecker6925@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_=
quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt =
0pt 0.8ex; padding-left: 1ex;">
<div>Platform:=A0 IBM z9</div>
<div>OS:=A0 SUSE10</div>
<div>Oracle:=A0 10gR2</div>
<div>=A0</div>
<div>Management is under the mistaken impression that the performance probl=
ems we are experiencing on a daily basis ALWAYS happen at the same time.=A0=
 To that end, they want me to set up a shell script that will run an AWR re=
port daily for each of the two time periods they believe the problems are o=
ccuring.=A0 I haven&#39;t been able to convince them we should run reports =
for the times we KNOW we had problems.=A0 I also haven&#39;t been able to l=
ocate a script to automatically run reports for the specific time periods--=
I&#39;m probably not entering the right search criteria.=A0 Does anyone hav=
e such a script or can point me in the right direction?<br clear=3D"all">

<br>-- <br>Sandy<br>Transzap, Inc.<br></div>
</blockquote></div><br>

--000e0cd70b34d57d5f0480eca44b--
--
http://www.freelists.org/webpage/oracle-l