Oracle Server Manager Release 2.3.2 Addendum | ![]() Library |
![]() Product |
![]() Contents |
![]() Index |
svrmgrm user=scott password=tiger service=t:oraserv:smtg73 area=deferredtrans
Note: Support for DEFERREDTRANSACTIONS has been retained for backward compatibility.
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
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.
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.
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.
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.
Note: In earlier versions of Server Manager, an error message was displayed.
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.
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 |
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.
STARTUP OPEN 'V7'
The syntax of the DESCRIBE command ::=
where:
name
The name of the object to describe.
INSERT INTO 'DESC' VALUES('onetwothree', 123); )
DESCRIBE emp
DESCRIBE payroll.emp
DESCRIBE FUNCTION payroll.emp
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.
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)
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. |
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. |
Cause: | You entered an invalid number for the cycle interval. |
Action: | Enter a value between 5 seconds and 99:99 (min:sec) inclusive. |
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. |
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. |
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. |
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. |
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. |
![]() | ![]() Copyright © 1996 Oracle Corporation. All Rights Reserved. |
![]() Library |
![]() Product |
![]() Contents |
![]() Index |