0360-0362

Previous Table of Contents Next

Page 360

Figure 15.17.
Software Manager.

SQL Worksheet

SQL Worksheet was designed to be the next generation of SQL*Plus and Server Manager rolled into one. It allows SQL, PL/SQL, and database management (startup and shutdown). SQL Worksheet is broken into two windows . (See Figure 15.18.)

Figure 15.18.
SQL Worksheet.

The bottom window contains the commands; the top window contains the results. This split-window approach is beneficial because the SQL statements do not scroll off the screen. The Previous Command and Next Command buttons allow the user to easily jump between SQL statements. Unfortunately, SQL Worksheet is missing some of the important features of SQL*Plus:

• A running query cannot be stopped . In SQL*Plus, it can be canceled at any time.

Page 361

• The screen does not repaint during a query.
• The bottom window cannot be used during a query.

NOTE

Although SQL Worksheet has its benefits, these drawbacks prevent it from replacing SQL*Plus or Server Manager. Most DBAs do not use this tool.

Storage Manager

Storage Manager helps the DBA administer the tablespaces, data files, and rollback segments. Table 15.4 lists the task that may be performed in each area.

Table 15.4. Tasks in Storage Manager.

Area	Tasks
Tablespaces	Create/drop tablespaces Take offline/online Add data files Change default storage parameters
Datafiles	Create data files Take offline/online Enable/disable autoextend
Rollback Segments	Create/drop rollback segments Take offline/online Change storage parameters Shrink

This tool is frequently used by DBAs to add data files.

CAUTION

Adding data files can be quite tricky with Storage Manager. It is easy to make the following mistakes:

• Adding a data file to the wrong tablespace
• Adding a data file with the size in kilobytes (the default) instead of megabytes

Page 362

Summary

Enterprise Manager is a tremendous improvement over the fragmented database-administration tools of the past. It allows almost all database management to be done from a single client,
regardless of network protocol or operating system. Although it has its downfalls, Enterprise Manager is the new fundamental tool in the administration of Oracle databases.

Previous Table of Contents Next