||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 17 -
Oracle’s Grid Integration Technologies
Scheduler has the following components:
This specifies when and how many times a job is executed.
This is a collection of metadata about what is run by the schedule. A
program can be a PL/SQL procedure, an executable C program, a Shell
script, or a java application, and so on. You can specify a list of
arguments for a program.
specifies what (program) needs to execute and at what time
(schedule). A job class defines a category of jobs that share common
resource usage requirements and other characteristics.
window is represented by an interval of time with a well-defined
beginning and end. It is used to activate different resource plans at
different times. A window group represents a list of windows.
Enable, Disable, and Drop a Program
You can use
the dbms_scheduler.create_program procedure to create a program. As
mentioned previously, a program is a collection of metadata about what
is to be run by the Scheduler. To create a program using
dbms_scheduler is really just to register a program with the
for creating a program using the Scheduler is as follows:
in pls_integer default 0,
Enable in Boolean default false,
Comments invarchar2 default null
For more information,
see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
can offer world-class remote Oracle database support at super-affordable prices.
Oracle DBA service provides 100% of the remote Oracle database administration
needs for your company, and includes 24x7 access to our staff of 100% OCP
Certified Oracle DBAs.
We require a 12 month service commitment and include the following services:
- Initial configuration review and problem identification
- Installation of Oracle statistics collection mechanisms and quarterly
database growth summaries
- Hourly monitoring of your Oracle database for pending problems
- Periodic performance analysis & identification of tuning activities
- Twenty Four hour Oracle emergency support
- Reporting and resolving all serious Oracle alert log messages
- Free use of the BC
- Quick response emergency support for production database outages
- Four hours of free remote DBA support every month. You can use these free
hours for any DBA activity, including database analysis, system design,
production migrations or personal mentoring.
information, please visit www.dba-oracle.com.