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 cron or the Windows at command. 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 ...

Get Oracle Database 11g—Underground Advice for Database Administrators now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.