Mastering Oracle Scheduler in Oracle 11g Databases Table Of Contents

Back to BOOK PAGE

Table of Contents

Preface
Chapter 1: Simple Jobs
Chapter 2: Simple Chain
Chapter 3: Control the Scheduler
Chapter 4: Managing Resources
Chapter 5: Getting Out of the Database
Chapter 6: Events
Chapter 7: Debugging the Scheduler
Chapter 8: The Scheduler in Real Life
Chapter 9: Other Configurations
Chapter 10: Scheduler GUI Tools
Index

• 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

Back to BOOK PAGE