book

Mastering Oracle Scheduler in Oracle 11g Databases

June 2009

Intermediate to advanced

240 pages

4h 30m

English

Read now

Unlock full access

An overview of Oracle SchedulerDatabase backgroundScheduling events in the databaseWhat this book coversWhat you need for this bookWho this book is forConventionsReader feedbackCustomer supportDownloading the example code for the bookErrataPiracyQuestions
Creating a userRunning your JobsPL/SQL blockStored procedureExecutableProgramDefining arguments for your jobsMetadata argumentsNormal application argumentsSummary
JobsChainsStatusesChains and stepsRulesEvaluation intervalPrivilegesSteps to create a chainHands-on with chainsProgramsSHUTDOWNCOPYFILESSTARTUPProgram stateDB ConsoleChain definitionRunning the chainTricks with chainsManipulating the running chainsAnalyzing the chainSummary
Job creationJob executionScheduler managementLoggingLog detail levelLog purgingSummary
Resource consumer groupCreating resource consumer groupsClassPlanWindowWindow groupsMonitoringProblems with Resource ManagerProblems that Resource Manager solvesSummary
SecurityInstallation on WindowsInstallation on LinuxUpgrading the remote job agentSilent install of the remote job agentBase releasePatch to the latest available levelPreparing the database for remote agent usageVerifying the XDB installationSetting the HTTP portCreating remote Scheduler objectsSetting registration passwordConfiguring a remote agentTroubleshootingMultiple agents on the same hostCredentialsCreating job—targeting UnixCreating job—targeting WindowsRuntime observations of the remote SchedulerResource ManagerSummary

Monitoring job eventsEvents in chainsEvent-based schedulingSummary
Unix—all releasesWindows usageBugsJob environmentChecks to do in the databaseSummary
Statistics collectionThe schedule_run procedureThe run procedureThe statob procedureThe drop_jobs procedureGenerating the jobsPerforming the analysisGenerating the scheduled runBackupsThings that can scare youDiving into the codeReading the event queueScheduling for the HOT backupsScheduling the DARC processScheduling the final BARC processHow to use the calendarToolsHow to schedule on the first day of a monthHow to schedule only on MondayHow to schedule on the first Monday of a monthHow to schedule on the first working day of a monthHow to schedule on the first working Monday of a monthHow to schedule on the nth Monday of a monthHow to schedule on the last working day of a monthHow to schedule in the first quarter of a yearHow to schedule on the first Monday of the first quarterSummary
RACJob creation/modificationThe job_class definitionStandby databasesCreating jobs in a logical standby databaseRunning jobs in a logical standby databaseSummary
DB ConsoleGrid ControlDbVisualizerSummary