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~
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 12:59:15 CST
