CHAPTER 14Database Maintenance

"Sometimes," he added, "there is no harm in putting off a piece of work until another day. But when it is a matter of baobabs, that always means a catastrophe. I knew a planet that was inhabited by a lazy man. He neglected three little bushes ..."

The Little Prince by Antoine de Saint-Exupéry

In my first job as a database administrator, working for a Fortune 100 company, I managed only three databases, each no more than a hundred megabytes in size, and had ample time for database maintenance. I performed regular database maintenance procedures to keep the databases in peak operating condition, including data archiving and purging and rebuilding of tables and indexes. I also published graphs of database and application ...

Get Beginning Oracle Database 11g Administration: From Novice to Professional 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.