Oracle7 Server Manager User's Guide | ![]() Library |
![]() Product |
![]() Contents |
![]() Index |
The Preface contains the following information:
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.
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 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.
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.
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.
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.
This chapter describes how to use Server Manager in line mode.
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.
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.
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:
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:
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.
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:
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.
![]() ![]() Prev Next |
![]() Copyright © 1996 Oracle Corporation. All Rights Reserved. |
![]() Library |
![]() Product |
![]() Contents |
![]() Index |