Limit search to available items
Book Cover
E-book
Author Rood, Ronald, author

Title Mastering Oracle Scheduler in Oracle 11g Databases
Published Birmingham : Packt Pub. May 2009

Copies

Description 1 online resource
Series From technologies to solutions
From technologies to solutions.
Contents Cover; Copyright; Credits; About the Author; About the Reviewers; 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 chainsAnalyzing 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 levelPreparing 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 environmentChecks 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 databasesCreating 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
Summary Schedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBook
Audience Scholarly & Professional Packt Publishing, Limited
SUBJECT Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760
Oracle (Computer file) fast
Subject Database management.
Relational databases.
Production schedulingxData processing
Database management
Relational databases
Form Electronic book
ISBN 9781847195982
1847195989
9781847195999
1847195997