Oracle7 Server Manager User's Guide

Library

Product

---

• Oracle Server Manager^(tm) User's Guide

• Preface
• Purpose of this Guide
• Audience
• How the Oracle Server Manager User's Guide Is Organized
• How to Use This Guide
• Conventions Used in This Guide
• Related Publications

• Introduction to Server Manager

• Overview of Server Manager
• What is Server Manager?
• Using Server Manager
• Starting Up Server Manager
• Server Manager Organization
• Server Manager Menus
• Connecting to an Instance
• Using Online Help
• Launching Server Manager in Context
• Global Parameters for Launch in Context
• Parameters for the Administration Manager
• Parameters for the SQL Worksheet
• Parameters for the System Monitors

• The Administration Manager

• Overview of the Administration Manager
• The Administration Manager
• Administration Drawers and Folders
• Common Interface Elements

• Managing Database Storage
• The Tablespaces Folder
• The Datafiles Folder
• The Rollback Folder

• Controlling Database Security
• The Users Folder

• The Profiles Folder
• The Roles Folder
• The Audit Folder

• Managing Instances and Sessions
• The Database Folder
• The Initialization Folder
• The Transactions Folder
• The Sessions Folder

• Backing Up and Recovering the Database
• The Backup Folder
• The Recovery Folder
• The Redo Logs Folder

• Viewing Schema Objects
• The Constraints Folder
• The Triggers Folder
• The Packages Folder
• The Links Folder
• The Synonyms Folder
• The Optimizer Folder
• The Explain Plans Folder
• The Snapshots Folder
• The Snapshot Logs Folder

• Managing a Replication Environment
• The Schemas Folder
• The Objects Folder
• The Registered Snapshots Folder
• The Masters Folder
• The Conflict Resolution Folder
• The Deferred Transactions Folder
• The Errors Folder
• The Request Log Folder

• The SQL Worksheet

• Using the SQL Worksheet
• The SQL Worksheet
• Executing Commands in the SQL Worksheet
• Using the Command History
• Saving Your Work
• Running Scripts from the SQL Worksheet
• Starting a Monitor from the SQL Worksheet

• System Monitors

• Overview of the System Monitors
• The System Monitors
• Using the System Monitors
• Starting a Monitor
• Common Interface Elements

• Monitoring System Performance
• The Circuit Monitor
• The Dispatcher Monitor
• The File I/O Monitor
• The Latch Monitor
• The Library Cache Monitor
• The Lock Monitor
• The Process Monitor
• The Queue Monitor
• The Rollback Monitor
• The Session Monitor
• The Shared Server Monitor
• The SQL Area Monitor
• The System I/O Monitor
• The System Statistics Monitor
• The Table Access Monitor
• The Tablespace Monitor

• Line Mode

• Using Server Manager in Line Mode
• Starting Server Manager in Line Mode
• Using Server Manager in Line Mode

• Reference

• Server Manager Command Reference
• Server Manager Commands
• @ (at symbol)
• ARCHIVE LOG
• CONNECT
• DESCRIBE
• DISCONNECT
• EXECUTE
• EXIT
• HELP
• HOST
• MONITOR
• PRINT
• RECOVER
• REMARK
• SET
• SHOW
• SHUTDOWN
• SPOOL
• STARTUP
• VARIABLE

• Server Manager Messages and Codes
• 00100-00199: Server Manager Line Mode Parsing Messages
• 00300-00399: Server Manager Line Mode Execution Messages
• 01500-01599: Server Manager Internal Messages
• 02000-02009: Server Manager About Box Messages
• 02010-02019: Server Manager Administration Window Internal Messages
• 02020-02029: Server Manager Event Handler Messages
• 02030-02039: Server Manager Connection List Messages
• 02040-02069: Server Manager Startup Messages
• 02070-02089: Server Manager Window and Menu Handler Messages
• 02090-02099: Server Manager Utility Messages
• 02100-02109: Server Manager Window Handler Messages
• 02110-02119: Server Manager Root Window Messages
• 02130-02139: Server Manager Administration Window Button and Folder Tab Messages
• 02140-02149: Server Manager Administration Window Messages
• 02150-02159: Server Manager Administration Window SQL Interface Messages
• 02160-02169: Server Manager Administration Window Menu Handler Messages
• 02170-02179: Server Manager Administration Window Lower Pane Messages
• 02180-02189: Server Manager Administration Window Object List Messages
• 02190-02199: Server Manager Administration Window Database Banner Messages
• 03000-03499: Server Manager Monitor Messages
• 03500-03536: Server Manager SQL Engine Messages
• 04000-04008: Server Manager Worksheet Command Messages
• 04009-04099: Server Manager Worksheet Messages
• 04501-04549: Server Manager Line Mode Messages
• 05500-05509: Server Manager User Program Interface Messages
• 06500-06529: Server Manager Oracle Toolkit II Messages
• 06600-06699: Server Manager Oracle Help Messages
• 07001-08529: Server Manager DRUID Messages
• 09500-09999: Server Manager Help System Messages
• 10000-10099: Server Manager National Language Support Messages
• 10500-10599: Server Manager Oracle Toolkit II Resource Manager Messages
• 11000-11499: Server Manager Core Messages
• 11500-11999: Server Manager Replication Messages

• Compatibility with SQL*DBA
• Functional Differences
• Cosmetic Differences
• Unsupported Options
• Obsolete Functionality

• Keyboard Shortcuts
• Menu Accelerators
• Menu Mnemonics

• Motif-Specific Operations
• Using Online Help with Server Manager for Motif

• Windows-Specific Operations
• Starting Server Manager with Windows File Manager
• Starting Server Manager with Windows Program Manager
• Starting Server Manager from the Windows MS-DOS Prompt
• Using Launch in Context with Windows File Manager
• Using Launch in Context with Windows Program Manager
• Using Launch in Context with MS-DOS

• Operating System Dependencies
• Operating System References

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product