Oracle7 Server Manager User's Guide

Library

Product

Contents

Index

Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

• ABORT mode
• Add Datafile dialog box
• Add Privilege to Role dialog box
• Add Privilege to User dialog box
• Add Quota dialog box [2]
• Administration Manager
  • about
  • drawers
  • File menu item
  • folders
  • object lists
  • property sheets
• administration requests
  • dropping
  • manually pushing
  • purging
• Alter Profile property sheet
  • about
  • Database Services page
  • Session and CPU page
  • Users page
• Alter Role property sheet
  • about
  • Definition page
  • General page
• Alter Rollback Segment property sheet
  • about
  • General page
  • Storage page
• Alter Tablespace property sheet
  • about
  • Default Storage page
  • General page
  • Rename Datafile dialog box
• Alter User property sheet
  • about
  • Default Role page
  • General page
  • Objects page
  • Privileges and Roles page
  • Quotas page
• Apply Recovery Archives dialog box
• ARCH background process, starting
• ARCHIVE LOG command
  • about
  • ALL option
  • LIST option
  • NEXT option
  • START option
  • STOP option
• archiving redo log files
  • about
  • archive location
  • device written to
  • re-archiving
  • stopping
• Audit folder
  • about
  • object list
• AUTORECOVERY option [2]
• background processes, startup after abnormal termination
• Backup folder
  • about
  • object list
  • online backup
• CATNOSVM.SQL script
• CATSVRMG.SQL script
  • about
  • running
  • version number
• CHAR datatype
  • displaying in line mode
  • in line mode
• checkpoint, forcing
• Circuit Monitor
• closing windows
• Command History dialog box
• command history
  • about
  • and Worksheet menu commands
  • retrieving a command from
• commands (Server Manager)
  • @ command
  • @ command, in a SQL Worksheet [2]
  • @@ command [2]
  • ARCHIVE LOG command
  • CONNECT command
  • DESCRIBE command
  • DISCONNECT command
  • EXECUTE command
  • executing operating system commands
  • EXIT command
  • HOST command
  • MONITOR command
  • PRINT command
  • programs, setting characteristics of
  • RECOVER command
  • REMARK command
  • SET command
  • SHOW command
  • SHUTDOWN command
  • SPOOL command
  • STARTUP command
  • VARIABLE command
• commands, executing in SQL worksheet
• comments, in scripts
• commit, forcing
• concurrency, instances, multiple
• Conflict Resolution folder
  • about
  • object list [2]
• CONNECT command
  • about
  • INTERNAL option
  • user SYS
• Connect dialog box
• connecting to a database
• connecting
  • about
  • as SYSOPER or SYSDBA
  • File menu item
  • SQL*Net service name
• connections
  • changing, in a SQL Worksheet
  • multiple
  • new windows and
• Constraints folder
  • about
  • object list
• Create Datafile property sheet
  • about
  • Datafile Specification page
• Create Profile property sheet
  • about
  • Assign Profile dialog box
  • Database Services page
  • Session and CPU page
  • Users page
• Create Role property sheet
  • about
  • Add Privilege to Role dialog box
  • Definition page
  • General page
• Create Rollback Segment property sheet
  • about
  • General page
  • Storage page
• Create Tablespace property sheet
  • about
  • Default Storage page
  • Edit Datafile dialog box [2]
  • General page
  • New Datafile dialog box [2]
• Create User property sheet
  • about
  • Add Privilege to User dialog box
  • Add Quota dialog box [2]
  • Default Role page
  • Edit Quota dialog box [2]
  • Find Schema Object dialog box [2]
  • General page
  • Privileges and Roles page
  • Quotas page
• cursors
  • disconnect and closing cursors
  • opened at CONNECT
• database files, recovering
• Database folder
  • about
  • mounting a database
  • object list
  • opening a database
  • shutting down a database
  • starting up a database
• database name, at startup
• database
  • changing connections
  • mounting [2]
  • opening [2]
  • recovering from SQL worksheet
  • shutting down
  • starting up
• Datafiles folder
  • about
  • creating a datafile
  • object list
  • renaming a datafile
• datafiles
  • creating
  • renaming
• DATE datatype, in line mode [2]
• DBA mode
• DBA privilege [2]
• deferred calls, displaying
• Deferred Transactions folder
  • about
  • Execute Deferred Transactions property sheet
    • Deferred Transactions page [2]
  • manually executing queued transactions
  • object list [2]
  • showing deferred calls
    • arguments of a selected call
  • showing information about deferred transactions
• deferred transaction, scheduling execution
• DESCRIBE command
• destination
  • archive
  • overriding default
• DISCONNECT command
• disconnecting [2]
• Dispatcher Monitor
• drawers, opening
• Drop Tablespace property sheet
• Edit Logfile dialog box
• Edit menu
• Edit Quota dialog box [2]
• editing, Edit menu
• elapsed timing [2]
• erred transaction
  • displaying
  • dropping
  • purging
• erred transactions, manually re-executing
• Errors folder
  • about
  • displaying erred transactions
  • dropping erred transactions
  • manually re-executing erred transactions
  • object list [2] [3]
  • purging erred transactions
• EXCLUSIVE mode
• EXECUTE command
• EXIT command
• exiting Server Manager
• Explain Plans folder
  • about
  • object list
• fetching rows in a query, setting MAXDATA
• File I/O Monitor
• File menu
• filtering statistics
• Find Schema Object dialog box [2]
• folder pull-down menus
  • about
  • using
• folder tabs
• folders
  • opening
  • pull-down menu
• FORCE option
• Grant Role dialog box
• Help menu
• Help system (Motif), bookmark [2]
  • contents [2]
  • finding a text string [2]
  • help dialog box
  • history [2]
  • index [2]
• Help system, using [2]
  • with Server Manager for Motif
• host name
• HOST command
• Icons, book
• IMMEDIATE mode
• in-doubt transactions
  • forcing a commit
  • forcing a rollback
• INIT.ORA file
• Initialization folder
  • about
  • object list
• Initialization parameters, displaying
• Instance drawer, about
• instances, connecting [2]
  • default
  • displaying current
  • multiple, sharing a database
  • shutting down
  • starting
• Latch Monitor
• launch in context
  • about
  • Administration Manager parameters
  • Area parameter
    • folder names
  • Command parameter
  • command-line parameters
  • global parameters
  • Menu parameter
  • Monitor parameter
    • monitor names
  • Object parameter
  • specifying a subsystem
  • specifying connect information
  • SQL Worksheet parameters
  • System Monitors parameter
  • using with Windows File Manager
  • using with Windows MS-DOS prompt
  • using with Windows Program Manager
• Library Cache Monitor
• line mode, about [2]
  • entering commands in
  • entering PL/SQL in
  • entering SQL in
  • running scripts from
  • starting
  • using
• Links folder
  • about
  • object list
• LIST option
• Lock Monitor
• log sequence numbers, listing
• log files
  • adding a group
  • adding a member
  • applying during recovery
  • dropping a group
  • dropping a member
  • renaming members
• log sequence numbers, for manual archiving
• log switch, forcing
• LOG_ARCHIVE_DEST parameter
  • ARCHIVE LOG LIST
  • overriding
• LOG_ARCHIVE_START parameter, ARCHIVE LOG command
• master database, adding to replicated environment
• Masters folder
  • about
  • Add Master Database property sheet
    • Master Specifications page
  • adding master databases
  • object list [2]
  • Schedule Execution property sheet
    • Schedule Specification page [2]
  • scheduling execution of deferred transactions
• menus
  • Edit menu
  • File menu
  • folder pull-down, about
  • folder pull-down, using
  • Help menu
  • Windows menu
• MONITOR command
• monitors
  • Circuit Monitor
  • descriptions of
  • Dispatcher Monitor
  • File I/O Monitor
  • File menu item
  • filtering statistics
  • Latch Monitor
  • Library Cache Monitor
  • Lock Monitor
  • Process Monitor
  • Queue Monitor
  • requirements to use
  • Rollback Monitor
  • sampling controls
  • Session Monitor
  • Shared Server Monitor
  • SQL Area Monitor
  • starting
  • starting from SQL worksheet
  • statistics lists
  • System I/O Monitor
  • System Statistics Monitor
  • Table Access Monitor
  • Tablespace Monitor
  • using
• Motif (Server Manager for), online help
• mounting a database
• mounting, shared databases
• New Logfile dialog box
• NORMAL mode
• NUMBER datatype, in line mode [2]
• object lists
  • about
  • refreshing
  • selecting from
  • sorting
• Objects folder
  • about
  • Add Master Replication Objects property sheet
    • Object Specifications page
  • adding replicated objects
  • object list
• online backup
• online help
• online redo log files, re-archiving
• opening a database
• Optimizer folder
  • about
  • object list
• Oracle Server releases supported by Server Manager
• Packages folder
  • about
  • object list
• page tabs
• pages
• parameter files (INIT.ORA files), specifying alternate
• passwords, CONNECT command
• PRINT command
• privileges, needed to use Server Manager
• Process Monitor
• Profiles folder
  • about
  • altering a profile
  • creating a profile
  • dropping a profile
  • object list
• profiles
  • altering
  • creating
  • dropping
• programs, setting characteristics of
• property sheets
  • about
  • page tabs
  • pages
• Queue Monitor
• quitting Server Manager
• RECOVER command
• recovery
• Recovery drawer, about
• Recovery folder
  • about
  • applying a log file
  • object list
• recovery
  • RECOVER command
  • SQL worksheet and
• redo log files
  • archiving
  • listing range of
  • re-archiving
• Redo Logs folder
  • about
  • adding a log file group
  • adding a log file member
  • checkpoint, forcing
  • dropping a log file group
  • dropping a log file member
  • Edit Logfile dialog box
  • Group Specification page
  • log switch, forcing
  • Member Specification page
  • New Logfile dialog box
  • object list
  • renaming a log file member
• refresh command, using
• Registered Snapshots folder
  • about
  • object list [2]
• Related publications
• REMARK command
• Remove Privilege from Role dialog box
• Rename Datafile dialog box
• Replication drawer, about [2]
• Request Log folder
  • about
  • Apply Administration Requests property sheet
    • Administration Requests page [2]
  • dropping administration requests
  • manually apply requests
  • manually executing job queues
  • object list [2]
  • purging administration requests
• resetting defaults
• Revoke Role dialog box
• Roles folder
  • about
  • adding privilege to role
  • altering a role
  • creating a role
  • dropping a role
  • granting a role
  • object list
  • removing privilege from role
  • revoking a role
• roles
  • adding privilege to
  • altering
  • creating
  • dropping
  • granting to user or role
  • removing privilege from
  • revoking from user or role
• Rollback folder
  • about
  • altering a rollback segment
  • creating a rollback segment
  • dropping a rollback segment
  • object list
  • placing rollback segment online
  • taking rollback segment offline
• Rollback Monitor
• rollback segments
  • altering
  • creating
  • dropping
  • placing online
  • taking offline
• rollback, forcing
• rolling forward
• running scripts, @ command [2]
  • @@ command [2]
• sampling controls
• saving
• Schema drawer, about
• Schema folder
  • about
  • execute DDL property sheet
    • DDL Text page
    • Master Databases page
  • executing DDL statements
  • object list
  • quiesce a schema
  • Replication Environment Summary
    • database information
    • Master Def or Master site information
    • schema information
    • snapshot site information
  • resuming replication activity
  • suspending replication activity
  • unquiesce a schema
• schema
  • adding objects to a replicated
  • display information about replicated
  • execute DDL statement on replicated
  • information about replicated
  • resuming replication activity
  • suspending replication activity
• scripts
  • running
  • running from line mode
  • running from SQL worksheet
• Security drawer, about
• SELECT command, MAXDATA
• Server Manager commands, executing
• Server Manager/LineMode
• Server Manager
  • about
  • components
  • database administration and
  • menus
  • Oracle releases supported by
  • portability
  • privileges needed to use
  • quitting
  • starting up
  • version banner
  • views, about
  • views, dropping
  • views, installing [2]
• SERVEROUTPUT
  • SET
  • SHOW
• service name
  • in window titles
  • specifying
• Session Monitor
• Sessions folder
  • about
  • disconnecting user session
  • object list
  • restricting sessions
• SET command
  • about
  • AUTORECOVERY option
  • INSTANCE option
  • SERVEROUTPUT
• shared disk systems, mounting shared
• shared mode, database
• Shared Server Monitor
• SHOW command
• showing SQL statements
• SHUTDOWN command
• Shutdown Database dialog box
• shutting down a database
• SM$VERSION synonym
• Snapshot Logs folder
  • about
  • object list
• Snapshots folder
  • about
  • object list
• snapshots, viewing information about
• SPOOL command
• spooling multiple log files
• SQL Area Monitor
• SQL statements, showing
• SQL Worksheet
  • about
  • connecting from
  • entering commands
  • executing commands in
  • executing Server Manager commands
  • File menu item
  • input pane
  • recovering a database
  • running scripts from
  • saving work
  • starting
  • starting monitors
  • using
  • Worksheet menu
• SQL*Net, specifying service names
• starting up a database
• starting up Server Manager
  • about
  • at Windows MS-DOS prompt
  • launch in context
  • using launch in context with Windows [2] [3]
  • with Windows File Manager
  • with Windows Program Manager
• STARTUP command
• Startup Database dialog box
• statistics lists
• Storage drawer, about
• supported Oracle releases
• Synonyms folder
  • object list
• SYS username, CONNECT INTERNAL
• System Global Area (SGA), displaying
• System I/O Monitor
• System Monitors
• System Statistics Monitor
  • about
  • cache statistics
  • enqueue statistics
  • parallel server statistics
  • redo statistics
  • SQL tuning statistics
  • user statistics
• Table Access Monitor
• tables, DESCRIBE command
• Tablespace Monitor
• Tablespaces folder
  • about
  • adding a datafile
  • altering a tablespace
  • creating a tablespace
  • dropping a tablespace
  • object list
  • placing tablespace online
  • taking tablespace offline
• tablespaces
  • adding a datafile to
  • altering
  • creating
  • dropping
  • placing online
  • recovering
  • taking offline
• Take Tablespace Offline dialog box
• tape drive, spooling multiple log files
• terminals, redirecting output
• timing, CPU and elapsed [2]
• Transactions folder
  • about
  • forcing a commit
  • forcing a rollback
  • object list
• transactions, committing at disconnect
• Triggers folder
  • about
  • object list
• tuning SQL, system statistics monitor and
• usernames
• Users folder
  • about
  • adding privileges to a user
  • altering a user
  • creating a user
  • disconnecting a user
  • dropping a user
  • object list
  • removing privileges from a user
• users
  • adding privileges to
  • altering
  • creating
  • disconnecting
  • dropping
  • removing privileges from
• VARIABLE command
• version banner
• window titles
• Windows menu
• Windows, starting up Server Manager [2] [3]
  • using launch in context [2] [3]
• Worksheet menu

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index