Re: Automate AWR report in Grid control
- From: "Vijay Vardhineni" <vvardhineni@xxxxxxxxx>
- To: prem.khanna@xxxxxxx
- Date: Mon, 12 Nov 2007 11:59:15 -0700
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@xxxxxxx> 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~
>
Other related posts:
