Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automate AWR report in Grid control
I think OP meant AWR report and not AWR snaps themselves.
Grid Control doesn't have AWR report scheduling capabilities - it just
presents you an interface to generate it on demand. There are not many
cases I can see why this wouldn't suit your needs.
You can schedule OS script/SQL*Plus and use awr*.sql scripts provided
in $ORACLE_HOME/rdbms/admin.
You can also call dbms_workload_repository.awr_report_html or
dbms_workload_repository.awr_report_text directly.
On Nov 12, 2007 1:59 PM, Vijay Vardhineni <vvardhineni_at_gmail.com> wrote:
> By default AWR runs for every one hour and retains the snapshots for one
> week. You can use the procedure
> DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings
> to modify the settings.
>
>
> Vijay
>
>
> On 11/12/07, Khanna, Prem <prem.khanna_at_eds.com> wrote:
> >
> >
> >
> > Friends,
> >
> > Have anyone tried to automate AWR report in grid control ?
> > Any clue ? ! Do I need to create my own job or report or is there any
> other simple means of doing it ?
> >
> > For example, I need to automate AWR report generation for a couple of
> databases everyday between 7 to 10 AM .
> >
> > Thanks,
> > ~jp~
>
>
-- Alex Gorbachev, Oracle DBA Brewer, The Pythian Group http://www.pythian.com/blogs/author/alex http://www.oracloid.com BAAG party - www.BattleAgainstAnyGuess.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 12 2007 - 18:38:21 CST
![]() |
![]() |