Content Inside :
This article is a brief overview of the management of automated database maintenance tasks in Oracle database 11g. These tasks run during maintenance windows scheduled to open over night. Configuration of the maintenance tasks, their schedules and resource usage is possible using Enterprise Manager or PL/SQL APIs. Basic task configuration The “Automated Maintenance Tasks Configuration” screen is the stating point for all maintenance task configuration. The “Maintenance Window Group Assignment” section provides the most granular level of control. It allows tasks to be removed or added to individual maintenance windows. Task Parameter Configuration The “Task Settings” section of the “Automated Maintenance Tasks Configuration” screen includes two “Configure” buttons. The “Configure” button next to the “Optimizer Statistics Gathering” task takes you to the “Global Statistics Gathering Options” screen. The maintenance windows are defined using the Oracle Scheduler. Oracle provide a separate active
maintenance window for each day, with all windows collected into a window group called “MAINTENANCE_WINDOW_GROUP”. Clicking the “Edit Window Group” button on the “Automated Maintenance Tasks Configuration” screen allows you to view and modify the window group. Resource Plan Configuration The “Edit Window” screen includes “View Resource Plan” and “Create Resource Plan” buttons. These buttons take you to the resource manager maintenance screens. All maintenance windows are assigned to the “DEFAULT_MAINTENANCE_PLAN” resource plan by default.
Tags : maintenance screens, window group, maintenance windows, global statistics, assignment section, resource plan, maintenance task, maintenance window, pl sql, configuration screen, maintenance tasks, group resource, oracle database, plan resource, group assignment
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.