Summary

Tuning the performance of the database is a multiple-step process. First, you’ll need to ask questions to figure out where the performance issue is and what the issue actually means. Several Oracle tools allow you to gather information and see history and current statistics, giving you more details regarding what is running and how the server is behaving.

The areas to check first in an Oracle database are different from those in a SQL Server database. Since locks and blocking are handled differently in Oracle, this area is further down on the list that it is in SQL Server. Indexes, statistics, and waits are the top areas to look at in an Oracle system to validate that the database has what it needs as input to create good execution plans ...

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.