Mastering Oracle Scheduler in Oracle 11g Databases Table Of Contents

Table of Contents

• Preface

• Chapter 1: Simple Jobs
• Creating a user
• Running your Jobs
• PL/SQL block
• Stored procedure
• Executable
• Program
• Defining arguments for your jobs
• Metadata arguments
• Normal application arguments
• Summary

• Chapter 2: Simple Chain
• Jobs
• Chains
• Statuses
• Chains and steps
• Rules
• Evaluation interval
• Privileges
• Steps to create a chain
• Hands-on with chains
• Programs
• SHUTDOWN
• COPYFILES
• STARTUP
• Program state
• DB Console
• Chain definition
• Running the chain
• Tricks with chains
• Manipulating the running chains
• Analyzing the chain
• Summary

• Chapter 3: Control the Scheduler
• Job creation
• Job execution
• Scheduler management
• Logging
• Log detail level
• Log purging
• Summary

• Chapter 4: Managing Resources
• Resource consumer group
• Creating resource consumer groups
• Class
• Plan
• Window
• Window groups
• Monitoring
• Problems with Resource Manager
• Problems that Resource Manager solves
• Summary

• Chapter 5: Getting Out of the Database
• Security
• Installation on Windows
• Installation on Linux
• Upgrading the remote job agent
• Silent install of the remote job agent
• Base release
• Patch to the latest available level
• Preparing the database for remote agent usage
• Verifying the XDB installation
• Setting the HTTP port
• Creating remote Scheduler objects
• Setting registration password
• Configuring a remote agent
• Troubleshooting
• Multiple agents on the same host
• Credentials
• Creating job—targeting Unix
• Creating job—targeting Windows
• Runtime observations of the remote Scheduler
• Resource Manager
• Summary

• Chapter 6: Events
• Monitoring job events
• Events in chains
• Event-based scheduling
• Summary

• Chapter 7: Debugging the Scheduler
• Unix—all releases
• Windows usage
• Bugs
• Job environment
• Checks to do in the database
• Summary

• Chapter 8: The Scheduler in Real Life
• Statistics collection
• The schedule_run procedure
• The run procedure
• The statob procedure
• The drop_jobs procedure
• Generating the jobs
• Performing the analysis
• Generating the scheduled run
• Backups
• Things that can scare you
• Diving into the code
• Reading the event queue
• Scheduling for the HOT backups
• Scheduling the DARC process
• Scheduling the final BARC process
• How to use the calendar
• Tools
• Summary

• Chapter 9: Other Configurations
• RAC
• Job creation/modification
• The job_class definition
• Standby databases
• Creating jobs in a logical standby database
• Running jobs in a logical standby database
• Summary

• Chapter 10: Scheduler GUI Tools
• DB Console
• Grid Control
• DbVisualizer
• Summary

• Index