LEADER 04636nam 2200673Ia 450 001 9910780782203321 005 20200520144314.0 010 $a1-282-15930-5 010 $a1-84719-599-7 010 $a9786612159305 035 $a(CKB)2430000000040701 035 $a(EBL)956360 035 $a(OCoLC)697724350 035 $a(SSID)ssj0000348707 035 $a(PQKBManifestationID)12084734 035 $a(PQKBTitleCode)TC0000348707 035 $a(PQKBWorkID)10346033 035 $a(PQKB)11757211 035 $a(Au-PeEL)EBL956360 035 $a(CaPaEBR)ebr10433562 035 $a(CaONFJC)MIL215930 035 $a(CaSebORM)9781847195982 035 $a(MiAaPQ)EBC956360 035 $a(PPN)22802837X 035 $a(EXLCZ)992430000000040701 100 $a20090827d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMastering Oracle Scheduler in Oracle 11g databases$b[electronic resource] $eschedule, manage, and execute jobs that automate your business processes /$fRonald Rood 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Publishing Ltd.$d2009 215 $a1 online resource (240 p.) 225 1 $aFrom technologies to solutions 300 $aIncludes index. 311 $a1-84719-598-9 327 $aCover; 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 327 $aManipulating 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 327 $aPatch 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 327 $aJob 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 327 $aStandby 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 330 $aSchedule, manage, and execute jobs that automate your business processes using Oracle Scheduler with this book and eBook 606 $aDatabase management 606 $aProduction scheduling$xData processing 606 $aRelational databases 615 0$aDatabase management. 615 0$aProduction scheduling$xData processing. 615 0$aRelational databases. 676 $a005.75/65 700 $aRood$b Ronald$01535086 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910780782203321 996 $aMastering Oracle Scheduler in Oracle 11g databases$93783067 997 $aUNINA