Overview of Tools for Typical Database Tasks

Table 5-1 shows the main tools in SQL Server and Oracle for performing some common DBA tasks.

Image

TABLE 5-1. DBA Tools for Common Tasks

You can see from the table that both SQL Server and Oracle provide a main tool for database administration: SQL Server Management Studio and Oracle Enterprise Manager (OEM). Let’s start with a look at OEM.

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.