Specific Tasks to Automate
The tasks we will examine will be:
1.
Gathering a complex set of database health statistics
2.
Automating a flush cycle for the shared pool
3.
Periodic reset of kept packages and procedures
4.
Automated re-calculation of table statistics based on percent
change
By examining how these four tasks are
accomplished using PL/SQL and DBMS_JOB you should be able to apply
the techniques shown to a host of other repetitive Remote DBA tasks.
