Curriculum
- 1 Section
- 6 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics6
- 1.1Managing Resources About Resource Management The Database Resource Manager Resource Manager Architecture
- 1.2Using Oracle Database Resource Manager Resource Manager Privileges Consumer Groups GRANT_SWITCH_CONSUMER_GROUP() Resource Plans Resource Plan Directives Programmatic Plans & Directives UTILIZATION_LIMIT Example UPDATE_PLAN_DIRECTIVE() Example Resource SUBPLANS Automatic & Adaptive Mapping DBMS_APPLICATION_INFO() Attributes Activating Resource Plans Monitoring Resource Allocation Explicit Consumer Group Switching Instance Caging
- 1.3Automating Tasks With The Database Scheduler (Basic) About Scheduling Systems The Oracle Database Scheduler Database Scheduler Framework Programs Schedules Jobs CREATE_JOB() Primary Attributes SET_ATTRIBUTE() & Secondary Attributes JOB_STYLE Attribute & Lightweight Job Example Job & Instance Log Management
- 1.4Automating Tasks With The Database Scheduler (Advanced) Job Classes Windows & Window Groups Chains Event-Based Vs. Time-Based Jobs Automated Maintenance Tasks
- 1.5Centralized Administration Using The Database Scheduler Centralized Scheduler Architecture Central Database Setup Remote Host Setup Defining Remote Jobs Submitting Remote Jobs
- 1.6Database Scheduler File Watchers & E-Mail Notification Email Notification File Watchers