SPM Plan Retention
Hi,
I'm using Oracle EE 11.2.0.1 on AIX 5.3
I'm looking at reducing the Plan Retention period from the default of 53 downwards (incrementally to 5) to purge any usused plans from the SMB. According to the documentation a weekly scheduled purging task runs as an automated task in the maintenance window. My questions are: -
1. Where can I find this 'automated task' in OEM?
2. Can the task be run manually - if so how?
3. How can I find out when the start time is of the 'weekly scheduled purging task' and 'weekly maintenance window'?
I've looked in the Scheduler > Automated Maintenance Tasks page of OEM and I can only Optimizer Statistics Gathering, Segment Advisor and Automatic SQL Tuning. The automatic sql tuning task is run every day, so this purging task can't be part of that...? I need to start purging unused plans, but I'd like to know when and how Oracle is going to start purging them automatically...
I'm using Oracle EE 11.2.0.1 on AIX 5.3
I'm looking at reducing the Plan Retention period from the default of 53 downwards (incrementally to 5) to purge any usused plans from the SMB. According to the documentation a weekly scheduled purging task runs as an automated task in the maintenance window. My questions are: -
1. Where can I find this 'automated task' in OEM?
2. Can the task be run manually - if so how?
3. How can I find out when the start time is of the 'weekly scheduled purging task' and 'weekly maintenance window'?
I've looked in the Scheduler > Automated Maintenance Tasks page of OEM and I can only Optimizer Statistics Gathering, Segment Advisor and Automatic SQL Tuning. The automatic sql tuning task is run every day, so this purging task can't be part of that...? I need to start purging unused plans, but I'd like to know when and how Oracle is going to start purging them automatically...
0