Mastering Oracle Scheduler in Oracle 11g Databases电子书

Mastering Oracle Scheduler in Oracle 11g Databases

Table of Contents

Mastering Oracle Scheduler in Oracle 11g Databases

Credits

About the Author

About the Reviewers

Preface

An overview of Oracle Scheduler

Database background

Scheduling events in the database

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code for the book

Errata

Piracy

Questions

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

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

3. Control the Scheduler

Job creation

Job execution

Scheduler management

Logging

Log detail level

Log purging

Summary

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

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

6. Events

Monitoring job events

Events in chains

Event-based scheduling

Summary

7. Debugging the Scheduler

Unix—all releases

Windows usage

Bugs

Job environment

Checks to do in the database

Summary

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

How to schedule on the first day of a month

How to schedule only on Monday

How to schedule on the first Monday of a month

How to schedule on the first working day of a month

How to schedule on the first working Monday of a month

How to schedule on the nth Monday of a month

How to schedule on the last working day of a month

How to schedule in the first quarter of a year

How to schedule on the first Monday of the first quarter

Summary

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

10. Scheduler GUI Tools

DB Console

Grid Control

DbVisualizer

Summary

Index