|
|
 |
|
Automating Oracle
Oracle Tips by Mike Ault |
Summary
In Each of the above Remote DBA tasks, significant time
and effort is saved by using Oracle provided packages and
self-generated scripts to automate repetitive tasks. Oracle has
provided the DBMS_JOB and DBMS_SQL stored packages of procedures
which should be used to automate virtually any task that the Remote DBA
does on a periodic basis.
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. |
 |
|
|
|
|