O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required