Oracle Server Manager Release 2.3.2 Addendum Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence

New Features and Updates


Launch in Context

Global Parameters

When using the launch in context feature, the NORMAL argument of the AS parameter should not be specified. If specified, NORMAL is ignored. When you use the AS parameter, specify either SYSDBA or SYSOPER.

AREA Parameter

The Deferred Transactions folder in the Replication drawer has been renamed the Deferred Trans folder. To go directly to this folder with the launch in context feature, substitute DEFERREDTRANS for DEFERREDTRANSACTIONS as the argument for the AREA parameter. For example:

svrmgrm user=scott password=tiger service=t:oraserv:smtg73 
	area=deferredtrans

Note: Support for DEFERREDTRANSACTIONS has been retained for backward compatibility.


Managing Database Storage

Coalescing a Tablespace

The new Coalesce option in the Tablespace menu coalesces (defragments) a tablespace. Coalescing a tablespace improves system performance by consolidating blocks of data and providing larger contiguous blocks of available free space.

Note: For an Oracle database prior to release 7.3, the Coalesce menu item is not available.

To coalesce a tablespace, select a tablespace in the object list then choose Coalesce from the Tablespace menu. The Tablespace folder and menu are shown in Figure 2 - 1.

Figure 2 - 1. Tablespace Folder and Menu

Coalesce Columns

In the Tablespace folder, two new columns, % Extents Coalesced and % Blocks Coalesced, have been added to the object lists. These columns display values from 0 to 100.

Low percentages in the coalesce columns indicate that the tablespace is fragmented. The Coalesce option of the Tablespace menu defragments a tablespace and increases the percentages in the % Extents Coalesced and % Blocks Coalesced columns.

Note: For an Oracle database prior to release 7.3, the % Extents Coalesced and % Blocks Coalesced columns display N/A (not available).

For more information about the COALESCE option of the ALTER TABLESPACE command, refer to Oracle7 Server SQL Reference. For more information about administering an Oracle database, see the Oracle7 Server Administrator's Guide.

Rollback Object List

PENDING OFFLINE has been added to the list of possible values for the Status of the rollback segment. This value indicates that the rollback segment was taken offline while it was busy.


Controlling Database Security

Users and Roles Folder

When you grant the DBA and RESOURCE roles to a user or role with Oracle7 release 7.2.2 or later, the user or role is also granted the UNLIMITED TABLESPACE system privilege.

When you revoke either role from a user or role, the UNLIMITED TABLESPACE system privilege is also revoked. The UNLIMITED TABLESPACE can also be revoked independent of the DBA and RESOURCE roles.


Backing up and Recovering the Database

When you choose the Apply option from the Recovery menu with an Oracle7 version 7.3 database, new dialog boxes provide detailed information on the state of the database recovery process.

Note: When using an Oracle database prior to release 7.3, the Apply Recovery Archives dialog box that was available in Server Manager 2.1 is displayed. See the Oracle Server Manager User's Guide for a description of that dialog box.

Applying Recovery Archives

To apply archived redo log files during media recovery, choose Apply from the Recovery menu. After you select the Apply option, the Apply Recovery Archives dialog box appears.

When you are using an Oracle7 version 7.3 database, the Apply Recovery Archives dialog box displays as shown in Figure 2 - 2.

Figure 2 - 2. Apply Recovery Archives Dialog Box

The Apply Recovery Archives dialog box for an Oracle7 version 7.3 database contains the following items:

Next Archive

A text entry field that displays the next suggested (default) archived log file to apply. You can edit the filename to apply a different archived log file.

Creation Time

The time at which the next archived log file was created. This field displays Unknown if the creation time is not available. The field displays N/A when recovery is complete.

Find Archive

Displays the standard file selection dialog box for your platform and allows you to select the next file to apply.

Show Remaining

Displays the Remaining Archives to Apply dialog box shown in Figure 2 - 3. For details on this dialog box, see page 2 - 7.

Database Status

The percentage and status of the recovery. The percentage of the database that has been recovered is the percentage of all required archived log files that have been processed at the current point in the recovery session. The status indicates why the recovery process has paused and returned control to the user. Possible explanations are: Need Archive, Archive Reused, End of Thread, and Unknown.

Show Status Details

Displays the Database Recovery Status Details dialog box shown in Figure 2 - 4. For more detail on this dialog box, see page 2 - 8.

Datafile Status

A multi-column scrolling list that displays information about the datafiles involved in the recovery process. The list contains three columns:

File # ID number of the datafile assigned by Oracle.

Filename Name of the datafile.

Recovery Status Recovery-related status of the datafile: In Recovery, Current, and Not Recovered.

History

An output window that displays prompts and status messages as recovery proceeds.

Save

Saves the contents of the History window to a file. The standard file selection dialog box for your platform displays and allows you to specify a filename.

Apply Next

Applies the file specified in the Next Archive field.

Apply All

Applies all remaining archived log files.

Cancel

Stops the recovery operation. The database is recovered up through the last log file applied. After the last log has been applied, the button's name changes to Done.

Help

Displays contextual help for this dialog box and provides access to all Server Manager online help.

Figure 2 - 3. Remaining Archives to Apply Dialog Box

Show Remaining

Displays the Remaining Archives to Apply dialog box shown in Figure 2 - 3. This box contains:

Remaining Archives Scrolling list that displays the full path and filenames of the archived log files that still need to be applied.

Done Closes the dialog box.

Help Displays contextual help for this dialog box and provides access to all Server Manager online help.

Figure 2 - 4. Database Recovery Status Details Dialog Box

Show Status Details

Displays the Database Recovery Status Details dialog box shown in Figure 2 - 4. This box contains:

Database Recovery Status The reason that the recovery process has paused and returned to the user: Need Archive, Archive Reused, End of Thread, and Unknown.

Checkpoint Time The point in time to which recovery has been completed. If no logs have been applied, this is the point in time at which recovery is starting. This value tracks the progress of recovery.

Redo Thread # The number of redo thread currently being processed.

Sequence # of Next Archive The sequence number of the archived log file that Oracle suggests be applied next.

Low SCN of Next Archive The low SCN (system change number) of the archived log file that Oracle suggests be applied next.

Creation Time of Next Archive The creation time of the archived log file that Oracle suggests be applied next. Displays Unknown if the creation time is unavailable.

Name of Previous Archive The full path and filename of the most recently applied file. If no archives have been applied or the previously supplied filename is invalid, None displays in this field.

Status of Previous Archive The status of the most recently applied archived log file. Possible values are: Release, Wrong Archive, Missing Name, and Unneeded Name. If there is no previous archive applied and no archive is in error, N/A displays in this field.

Done Closes the dialog box.

Help Displays contextual help for this dialog box and provides access to all Server Manager online help.


Managing Database Instances

If you have SYSOPER privileges, you can now start up or shut down a database instance from the Instance drawer's Database folder. However, because SELECT is not part of the SYSOPER privileges, no database objects will appear in the object list.

Note: In earlier versions of Server Manager, an error message was displayed.


Monitoring System Performance

Common Interface Elements

When displaying very large values, the monitors may represent individual statistics in a slightly different format, such as dropping least-significant digits after a decimal place or converting numbers to exponential format.

Sampling Controls

The minimum sampling interval for monitor statistics has been lowered from 15 to 5 seconds.

The Latch Monitor

The Latch Monitor no longer uses the V$LATCHNAME table. SELECT privileges on this table are no longer required to use this monitor.

The Library Cache Monitor

The Name Space column of the Library Cache Monitor has been renamed the Namespace column.

The Process Monitor

The Process Monitor previously displayed only the server-side Oracle processes. Many users connected via SQL*Net would have a server-side process with no username in the V$PROCESS table or with no terminal associated with the users. The Process Monitor now joins the V$PROCESS table with the V$SESSION table. In cases where the username or terminal are unidentified in V$PROCESS (previously shown with a ?), the information from the V$SESSION table is displayed if it exists.

If the username is taken from the V$SESSION table, it is displayed in parentheses to avoid confusion with process owners on the server machine. To use the Process Monitor, SELECT privileges are required on the V$SESSION table and the V$PROCESS table.

The Rollback Monitor

Two of the column titles in the Rollback Monitor are incorrect in the illustration of the monitor in the Oracle Server Manager User's Guide. The leftmost column is now labelled as the Rollback Segment column and the column next to it is labelled as the RS [Rollback Segment] ID. The Status column has been added to the far right of the monitor display to show whether the Rollback Segment is online or offline.

The Session Monitor

A large number of statement types have been added to the Session Monitor by joining with the AUDIT_ACTIONS table. Many statements which used to appear as UNKNOWN display the proper statement type. The text descriptions of a few statement types have changed slightly as a result. To use the Session Monitor, SELECT privileges are required on the AUDIT_ACTIONS table.

The System Statistics Monitor

The System Statistics Monitor now has a slightly different appearance. To accommodate a new operating system class of statistics, the Statistic Name field has been substantially widened.


Viewing Tablespaces for Large Databases

For large databases consisting of 30 or more tablespaces, you can now view information on all tablespaces simultaneously. A new button (...) has been added to the following property sheets containing Tablespace pop-up lists.

Drawer Folder Property Sheet
Storage Datafile Datafile->Create
Storage Rollback Rollback->Create
Security Users User->Create->General
Security Users User->Create->Quotas->Add
Security Users User->Alter->General
Security Users User->Alter->Quotas->Add
A tablespace pop-up list can display up to 30 tablespaces. To view all tablespaces within the database, press the All Tablespaces button (...) located beside the Tablespace pop-up list. A dialog box appears showing all tablespaces.

Figure 2 - 5. All Tablespaces Button

Figure 2 - 6. All Tablespaces Dialog Box

Attention: The Tablespace button is active only when there are more than 30 tablespaces in the connected database.


Using the SQL Worksheet

Executing Commands in the SQL Worksheet

If you have correctly configured your Motif environment, the Enter key on the numeric keypad can be used as a shortcut for the Execute button and Execute menu command when using the SQL Worksheet.


Server Manager Command Changes

Using Reserved Words

If a reserved word is used as an object name in a Server Manager command, it must be enclosed in quotes. For example, to start up a database that is named with the reserved word V7, issue the command as follows:

STARTUP OPEN 'V7'

DESCRIBE

The DESCRIBE command, which describes a function, package, package body, procedure, table, or view, has several enhancements.

The syntax of the DESCRIBE command ::=

where:

name

The name of the object to describe.

Attention: This means that DESC has been added to the list of Server Manager reserved words. If you have a database object named DESC, you need to place quotes around the name to show that it is an object name. For example:

	 INSERT INTO 'DESC' VALUES('onetwothree', 123); )

	DESCRIBE emp

	DESCRIBE payroll.emp

	DESCRIBE FUNCTION payroll.emp

Note: Some versions of PL/SQL allow the user to describe a package by giving the package name, and some versions require the user to specify an object in the package to describe. Server Manager supports package description for those versions of PL/SQL which support this functionality.

SPOOL

When long lines of text are written to a spool file or to a terminal, newline codes are inserted in the text if the lines exceed the maximum allowable line length for the platform.

SET

Changes to the SET command are as follows:

The syntax of the SET command ::=

APPINFO

Registers the Server Manager application through the database's DBMS_APPLICATION_INFO package (Oracle 7.2 or later). By default, the APPINFO function is set to OFF.

Application registration allows DBAs to see what software is currently running to better monitor resource utilization for database tuning. When APPINFO is turned on, application registration proceeds normally. If a SQL script is not being run, the default registration text string is "Oracle Server Manager." Optionally, you can create a customized registration text string. If a script is being run through Server manager, the script name is used as the registration text string.

Examples:

Text String Registers as:

SET APPINFO abc abc

SET APPINFO abc def abc

SET APPINFO "abc def" abc def

SET APPINFO 'abc def' abc def

SET APPINFO "abc def Error

SET APPINFO 'abc def Error

>svrmgrl command="SET APPINFO ON"

Note: This procedure applies to Server Manager Line Mode only and not the SQL Worksheet.

FETCHROWS integer

Limits the number of rows returned by a query. Useful with ordered queries for finding the "top ten" items in a category, for example. Also used with unordered queries to find the "first n" records that satisfy a given criteria. integer must be in the range 1-999,999.

If integer is not specified, SQL statement processing returns to the default method, returning all rows.

SHOW

The APPINFO option has been added to display the application registration information defined by SET APPINFO.

The syntax of the SHOW command ::=

where:

APPINFO

Shows the current status (ON/OFF) and the application registration text.

Example

SHOW APPINFO

returns a display such as:

APPINFO             ON      (USERTEXT: Oracle Server Manager)
 


New Error Messages

MGR-00109 invalid CYCLE value

Cause:An invalid value was specified for the SET CYCLE command.
Action:Specify a SET CYCLE value between 5 seconds and 99:99 (min:sec) inclusive.
MGR-00148 invalid APPINFO switch

Cause:An invalid option for the SET APPINFO command was specified.
Action:Use either ON, OFF or user text as an option for the SET APPINFO command.
MGR-00306 monitor cycle interval time out of range (5-%d)

Cause:You entered an invalid number for the cycle interval.
Action:Enter a value between 5 seconds and 99:99 (min:sec) inclusive.
MGR-02075 an error occured while creating a new SQL Worksheet window

Cause:You have encountered an internal error in Server Manager.
Action:Try closing one or more SQL Worksheet windows. If the problem persists, call Customer Support with a complete set of circumstances and error messages.
MGR-02081 an error occured while creating a new monitor window

Cause:You have encountered an internal error in Server Manager.
Action:Try closing one or more monitor windows. If the problem persists, call Customer Support with a complete set of circumstances and error messages.
MGR-02082 an error occured while cloning a connection

Cause:You have encountered an internal error in Server Manager.
Action:Try closing one or more Administration Worksheets, closing one or more SQL Worksheets, or closing all monitor windows. If the problem persists, call Customer Support with a complete set of circumstances and error messages.
MGR-03537 an error occured during APPINFO registration

Cause:The package SYS.DBMS_APPLICATION_INFO cannot be accessed.
Action:Check if SYS.DBMS_APPLICATION_INFO exists. Make sure the user has the required privileges to run the package. Ensure that the database is OPEN.
MGR-03538 expected a number (1-999999), not "string"

Cause:You attempted to set FETCHROWS to a non-numeric value or a number outside of the legal range.
Action:Use a value in the range 1-999,999.




Go to previous file in sequence Prev Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index