Oracle Server Manager User's Guide

• 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