Automating day-to-day tasks
Options to automate the DBA tasks mentioned in the previous chapter include some of the following:
- DBMS_SCHEDULER: Oracle-supplied PL/SQL package that comes preinstalled
- OS scheduling commands: Certain tasks such as monitoring file space usage and removing old trace/log files are often scheduled using something like Unix
cronor the Windows
atcommand. The best options include tasks that need to run no matter the database state—down, up, or mounted.
- OEM Grid Control Intelligent Agent: Requires installation and configuring to run OS type commands. A very useful Enterprise-wide monitoring tool but quite an investment in time to configure and maintain for multiple servers.
Let's look at an example task and apply it to each ...