Oracle Enterprise Manager Oracle Standard Management Pack Readme
Release 2.1.0.0.0

A76911-01

Oracle® Standard Management Pack

Readme

Release 2.1.0.0.0

February 2000

Part No. A76911-01

Table Of Contents

Introduction

Compatibility

Documentation and Help

Oracle Performance Manager

Oracle TopSessions

Oracle Index Tuning Wizard

DB Diff

DB Capture

General Information

Introduction

Purpose of this Document

This document notes differences between the delivered Oracle Standard Management Pack 2.1 product and its documented functionality. It also includes information on the Oracle Standard Management Pack documentation, and late-breaking information concerning this production release.

License Restrictions and Warranty Disclaimer

The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or decompilation of the Programs is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.

Restricted Rights Notice

If the Programs are delivered to the US Government or anyone licensing or using the Programs on behalf of the US Government, the following notice is applicable:

Programs delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the Programs including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

Hazardous Applications

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail-safe, back up, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.

Trademark Notice

Oracle is a registered trademark of Oracle Corporation. All other company or product names mentioned are used for identification purposes only and may be trademarks of their respective owners.

Compatibility

Oracle Database Compatibility Matrix

The following matrix lists the compatibility of the Oracle Standard Management Pack Release 2.1 with specific releases of the Oracle Server. If a component is certified to run with a specific server release, then a "yes" is placed for that entry.

ORACLE SERVER  

Feature  

7.3.x  

8.0.x  

8.1.5  

8.1.6  

Oracle Standard Management Pack  

yes  

yes  

yes  

yes  


Note:

The Oracle Performance Manager requires that a minimum release of the 8.0.4.1 Oracle Data Gatherer is installed and running. The Oracle Data Gatherer may be used to monitor 7.3.x and later servers.  


Documentation and Help

Online Documentation

The Oracle Enterprise Manager products provide online documentation in HTML format.

Online Context-Sensitive Help

The Oracle Enterprise Manager products provide online context-sensitive help. You can access online help for a product in multiple ways:

Oracle Performance Manager

Displaying Large Chart Groups

Displaying of large chart groups or large number of individual charts (more than 15 at a time) is not recommended on systems having less than 48 MB of memory.

Chart Window Not Large Enough

If the chart window is not large enough to display the chart, only the legend will appear in the chart. Resize the window to view the data.

Services Added At Runtime Are Not Saved

Any service added to the navigator at runtime is only visible in the navigator during that session. To make the service available for future sessions, it must be added to the Oracle Enterprise Manager discovery cache through the console.

Collecting Disk Statistics for a Windows NT Host

In order to collect disk statistics for a Windows NT host, you must enable disk statistics collection on Windows NT before using Performance Manager or Capacity Planner. This is done by typing the following command on the host to be monitored:

diskperf -Y

Disk statistics will then be enabled the next time the system is restarted.

User-Defined Charts

User-defined charts in do not support a drilldown to another chart.

Memory Leak When Chart Is Displayed

There is a known memory leak each time a chart is displayed and dismissed which will require a restart of the tool in order to release memory used by the monitor.

Create-Like Feature

If the create-like feature is used to copy a user-defined chart from one database to another, the query uses "select *" and the target database has a different number of columns an unhandled ArrayIndexOutOfBoundsException will occur.

Error When Attempting to Connect to a Target

If an error occurs while attempting to connect to a target (other than a database), the credentials fields in the logon dialog are reset to their default values.

Killing a Session

When killing a session from the lock chart no confirmation dialog is displayed, but the session is killed immediately.

Oracle TopSessions

Automatic Refresh Interval

If the TopSessions automatic refresh interval is shorter than the time it takes to do a refresh, TopSessions will thrash in a continuous loop. To break the loop, click on the "Refresh Mode" button on the toolbar to toggle back to the manual refresh mode.

Short Refresh Intervals

Do not leave TopSessions on auto-refresh with very short refresh intervals (under 20 seconds) for extended periods of time (several hours). Doing so may cause excessive system resource usage.

Oracle Index Tuning Wizard

Oracle Expert and Oracle SQL Analyze

Note that chapter 3 of the Getting Started with the Oracle Standard Management Pack manual, Introduction to Oracle Index Tuning Wizard, refers to two other Oracle applications: Oracle Expert and Oracle SQL Analyze. These two products are supplied with the optional Oracle Tuning Pack. They are not required to use the Index Tuning Wizard.

DB Diff

Comparing Characteristics of Two Users

To compare the characteristics of two users having different names, you can use a schema map to equate the two users. To do this, you must specify at least one schema object type to compare, then filter out all schemas from the comparison. This method avoids comparing schema objects in addition to the users.

Displaying Changed or Different SQL

When displaying changed or different SQL or PL/SQL text (as in views, functions, and trigger definitions, DB Diff initially displays only a single line of text. You can enlarge the display row vertically to display all the text.

Text in Textual Diff Viewer

In the Textual Diff Viewer, text that is present in the left-hand side but not in the right-hand side is marked as "deleted" (colored blue in the viewer), whereas text that is present in the right-hand side but not the left-hand side is marked as "inserted" (colored green).

Title in Textual Diff Viewer

The title on the right-hand side of the Textual Diff Viewer is incorrect (it is always the same as the left-hand side title).

DB Capture

Specifying "Generate SQL"

If you specify "Generate SQL" in DB Capture, but also specify to capture the baseline "later," the SQL will not be generated when you later capture the baseline. You can generate the SQL in the Baseline Viewer once the baseline has been captured. (1,041,775)

Specifying "Generate SQL" and Baseline Is Large

If you specify "Generate SQL" and the baseline is very large, the "Close" button on the Capture Progress window becomes active before the SQL script has been fully generated and stored. If you immediately click "Close" a message box with a Fatal Error message may appear. If you dismiss this message box, the Baseline Viewer will launch. The capture of the baseline is not affected by this situation, and the generated SQL script is complete. (1,105,176)

Capturing Baselines

You cannot capture baselines against a version 7.3.4 Oracle database, whose character set is something other than ASCII. The capture will fail with error ORA-01026. (1,171,762)

General Information

Change Management Applications

The following change management applications are provided with the Oracle Standard Management Pack:

These applications are a subset of the applications that are provided with the Oracle Change Management Pack. Note that with the Oracle Standard Management Pack, you have read-only access to database object definitions, and you cannot create change plans.

In the Standard Management Pack, you may see references to other Change Management Pack applications and features. Ignore the information about these applications and features.

Cannot Use Context Menus to Access Change Management Applications

In the Standard Management Pack, you cannot access Change Management applications by using context menus in Enterprise Manager or DBA Studio. (That is, when you click the right mouse button on a folder or object under a database, you cannot launch Change Management applications from the resulting menu.) To use Change Management applications, start Change Manager from the Start menu, or from Enterprise Manager (Tools menu or Change Management Pack drawer).



Copyright © 2000 Oracle Corporation.
All Rights Reserved.