|
|
| |
 |
|
Automating Oracle
Oracle Tips by Mike Ault |
Abstract
The database administrator’s job is filled with
repetitive tasks. Whether it be in the area of performance
monitoring, resource usage or backup and recovery, there are many
jobs that require repeating the same set of commands. Time was that
you have to use operating system based tools such as cron on UNIX or
the job queues on VMS to schedule any automated tasks against the
database. The biggest problem with automated scripts was that many
layers of error trapping had to be built in to prevent the script
from carrying on even after a critical failure. Since early Oracle 7
releases the DBMS_JOB package and its associated job queues has been
available for automating internal Oracle related tasks. This
presentation will show how repetitive Oracle Remote DBA tasks can be
automated using PL/SQL packages, procedures and the DBMS_JOB job
queues.
SEE CODE DEPOT FOR FULL SCRIPTS
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
