Object Maintenance
Along with gathering statistics information about the objects, some maintenance and checks need to be done on the objects themselves. There might be fragmentation, so that the object needs to be rebuilt. Invalid objects might need to be recompiled. Even grants and permissions can be considered part of object maintenance.
SQL Server has some of these tasks as part of the maintenance jobs. Oracle has advisors in place to advise if actions should be taken. Additionally, you can implement scripts to take care of object maintenance.
Index Rebuild
In examining the database objects, you may see some that appear fragmented and in need of a rebuild. Such rebuilds increase log activity, put additional resources on the system, and may ...
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.
