CHAPTER 7Database Maintenance
If there were no database users, data growth, or business modifications, the database could be installed and left alone. But as we all know, there are constant changes: application upgrades, new business requirements, different access needed by users, and just more data. So, installation isn’t enough, and there is a constant need for monitoring databases and running maintenance jobs to maintain stable systems.
In the previous chapter, we looked at one big part of database maintenance: running backups and making sure you are able to recover from failures and errors. In this chapter, we will look at maintenance that can prevent some issues or serve as a warning to help you avoid problems about to happen.
Get Oracle Database Administration for Microsoft SQL Server DBAs 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.
