Oracle Server Manager User's Guide
Server Manager Organization
Server Manager's graphical interface is divided into three major components:
The following sections give you an overview of these components.
Administration Manager
The Administration Manager is the primary administrative component of Server Manager. You will probably use the Administration Manager to perform most of your administrative tasks.
The Administration Manager divides database administration tasks into categories:
- Managing instances and sessions
- Backing up and recovering a database
- Managing a replication environment
Each of these categories is associated with its own pull-down menus and dialog boxes.
The Administration Manager and these categories of tasks are discussed in detail in Part II , "The Administration Manager."
SQL Worksheets
A SQL Worksheet allows you to dynamically enter SQL statements, PL/SQL code, and Server Manager commands. You can also run scripts from a SQL Worksheet.
A SQL Worksheet maintains a history of the commands you have entered. Thus, you can use the SQL Worksheet to edit and re-execute an earlier command without having to retype it.
You can have multiple SQL Worksheets open at a time, each of which is separate from the others. So, you can commit or roll back work in each worksheet independently.
SQL Worksheets are discussed in detail in Part III, "The SQL Worksheet."
System Monitors
The System Monitors allow you to gather and inspect performance statistics. These statistics can be useful for tuning your database.
The types of System Monitors are:
- Library Cache · System I/O
By selecting which aspects of system performance you want to monitor, you can view performance statistics. You can sample these statistics as frequently as you like by setting sampling intervals.
The System Monitors and the specific types of statistics you can monitor are discussed in detail in Part IV , "System Monitors."