| Oracle7 Server Manager User's Guide |  Library |
 Product |
 Contents |
 Index |
| Oracle7 Server Manager User's Guide | Library |
Product |
Contents |
Index |
This section describes the purpose and organization of this guide: the Oracle Server Manager User's Guide. This section also illustrates the conventions used in this guide.
The Preface contains the following information:
This guide describes how to use Oracle Server ManagerTM, Oracle's database administration tool. This guide describes Server Manager's graphical component (Server Manager/GUI) and line mode component (Server Manager/LineMode).
Information in this guide applies to Server Manager running on all platforms. Where some functionality may differ from platform to platform, this guide refers you to your operating system-specific documentation.
This guide is written for those who wish to use Oracle Server Manager to perform database administration tasks.
This guide assumes you are familiar with the administrative tasks you wish to perform. If you are not, refer to the Oracle7 Server documentation set. The Oracle7 Server documentation set contains specific and thorough descriptions of the database administration tasks you can perform with Server Manager. In addition, the Oracle7 Server documentation set provides recommendations on how to administer your database optimally.
If you have not yet read the introductory chapters of the Oracle7 Server Administrator's Guide, we recommend that you do so. These chapters describe the specific responsibilities of a database administrator.
Because Server Manager is available for several different Graphical User Interfaces (GUIs), this guide also assumes that you are familiar with the operation of your GUI. Refer to the user interface documentation for your system, if necessary.
This guide is divided into parts and chapters, as described below.
Chapter 1: Overview of Server Manager
This chapter describes the overall organization and behavior of Server Manager's graphical interface. It discusses connecting to one or more databases with Server Manager. It also describes how to use Server Manager's launch in context facility to start up Server Manager and jump to a specified place in the graphical interface.
Chapter 2: Overview of the Administration Manager
This chapter introduces the Administration Manager. It also describes the user interface elements used in the Administration Manager.
Chapter 3: Managing Database Storage
This chapter explains how to use the Administration Manager to manage the datafiles, tablespaces, and rollback segments in your database.
Chapter 4: Controlling Database Security
This chapter describes how to use the Administration Manager to manage users, roles, and profiles. It also describes how to view the audit options set for your system.
Chapter 5: Managing Instances and Sessions
This chapter describes how to use the Administration Manager to start up or shut down your database, and examine the values of the initialization parameters used to start up the instance. It also describes how to manage in-doubt transactions and users' sessions.
Chapter 6: Backing Up and Recovering the Database
This chapter describes how to use the Administration Manager to back up your database, perform recovery, and manage the redo log files.
Chapter 7: Viewing Schema Objects
This chapter describes how to use the Administration Manager to examine various objects in your database. It also explains how to determine which objects have been analyzed and how to list the SQL statements whose execution plans are stored in the PLAN_TABLE.
Chapter 8: Managing a Replication Environment
This chapter describes how to use the Administration Manager to manage and view information about your replication environment.
Chapter 9: Using the SQL Worksheet
This chapter explains how to use the SQL Worksheet to enter ad hoc SQL and PL/SQL statements. It also describes the editing capabilities of the SQL Worksheet, as well as the command history and session log features.
Chapter 10: Overview of the System Monitors
This chapter introduces the System Monitors. It describes the interface elements common to the monitors available in Server Manager.
Chapter 11: Monitoring System Performance
This chapter describes the System Monitors and statistics that you can view using Server Manager.
Chapter 12: Using Server Manager in Line Mode
This chapter describes how to use Server Manager in line mode.
Appendix A: Server Manager Command Reference
This appendix describes the Server Manager commands available in the SQL Worksheet and in line mode.
Appendix B: Server Manager Messages and Codes
This appendix describes the messages generated by Server Manager, and lists probable causes and actions for each message.
Appendix C: Compatibility with SQL*DBA
This appendix describes the differences in functionality and behavior between Server Manager/Line Mode and SQL*DBA.
Appendix D: Keyboard Shortcuts
This appendix lists the keyboard shortcuts implemented in Server Manager.
Appendix E: Motif-Specific Operations
This appendix describes operations that are specific to running Server Manager under Motif.
Appendix F: Windows-Specific Operations
This appendix describes operations that are specific to running Server Manager under Microsoft Windows.
Appendix G: Operating System Dependencies
This appendix lists all the operating system-specific references within this guide.
This Oracle Server Manager User's Guide has been designed to be used closely with the Oracle7 Server documentation set. While this guide teaches you how to use Server Manager to perform database administration tasks, the Oracle7 Server documentation set describes the reasons for and the implications of performing these tasks. Consequently, you should refer to the Oracle7 Server documentation set while using Server Manager to perform your administrative tasks.
Before using Server Manager, you should read Chapter 1, "Overview of Server Manager." After reading Chapter 1, you may choose to proceed directly to those chapters that are relevant to the tasks you plan to perform using Server Manager.
Before using the Administration Manager, you should read Chapter 2, "Overview of the Administration Manager." Chapter 2 provides an overview of the organization and user interface elements of the Administration Manager.
The following sections explain the conventions used in this guide.
The syntax diagrams in this guide show the complete syntax for the Server Manager commands. Syntax diagrams are composed of these items:
Keywords Keywords are words that have special meanings. In the syntax diagrams in this guide, keywords appear in uppercase. When you specify them, they can be in uppercase or lowercase, but they must be used exactly as they appear in the syntax diagram.
Parameters Parameters act as place holders in syntax diagrams. They appear in lowercase. Parameters are usually names of schema objects, Oracle datatypes, or expressions. When you see a parameter in a syntax diagram, you should substitute an object or expression of the appropriate type. Note that parameter names appear in italics in the text of this guide.
Graphic Components Syntax diagrams use lines and arrows to show syntactic structure. The following list shows combinations of lines and arrows and their meanings within railroad diagrams:
This guide also contains examples. This is an example of a SELECT statement:
SELECT * FROM emp
Note that the text of examples appears in a different font than the text of the guide.
Examples in this guide follow these case conventions:
However, in the text of this guide, names of database objects and their parts appear in uppercase.
Included throughout this guide are illustrations of various Server Manager windows, dialog boxes, and alert boxes. The illustrations show Server Manager Version 2.1.3 running on Microsoft Windows NT.
Special icons are provided to alert you to particular information within the body of this guide and within other manuals.
Additional Information: Operating System-Specific Documentation Where necessary, this guide refers you to your operating system-specific Oracle documentation for additional information.
Attention: The attention icon highlights information that is important to remember when performing the described task.
Suggestion: The suggestion icon signifies suggestions and practical hints that can be helpful when using Server Manager.
Warning: The warning icon indicates information that you should be aware of before you perform the action described in the current section.
The Oracle Server Manager User's Guide is one of many books that explain various parts of an Oracle database system.
In many sections of this guide, the information is general because the guide is written to apply to Server Manager working under any operating system and configuration. Therefore, you will also find many references in this book to important information in the related publications. The related books referred to in this guide are listed below:
Oracle Corporation also publishes several ASCII files, which are available on your distribution media. These files describe differences between minor releases of Oracle software that are not accompanied by new manuals. These files are usually named README.DOC, BUGFIX.DOC, BUGHST.DOC, and RESTRICT.DOC. Read these files to learn about changes to the software that are not described in the regular manuals.
The release notes for Server Manager are also available on your distribution media. The file is commonly called SVRMGR.TXT.
Additional Information: The exact names and locations of the files mentioned above may vary, depending on your operating system. See your operating system-specific Oracle documentation for information about these files.
We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of our printed manuals is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form is not available, please use the following address or FAX number.
Server Manager Product Manager
Oracle Corporation
500 Oracle Parkway
Redwood City, CA 94065
U.S.A.
FAX: 415-506-7200
|
Prev Next |
 Copyright © 1996 Oracle Corporation. All Rights Reserved. |
Library |
 Product |
 Contents |
 Index |