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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial