|Oracle Enterprise Manager Getting Started with the Oracle Standard Management Pack
Part Number A88749-02
The Oracle Standard Management Pack is an optional set of applications that provide advanced tools that allow you to monitor and diagnose problems, tune high impact indexes, and track and compare changes in your Oracle9i environment.
The Oracle Standard Management Pack includes the following applications:
Applies real-time, graphical Oracle and host monitoring through an extensive array of customized performance charts.
Pro actively optimizes the indexes in your database environment.
Lets you display baselines created using Create Baseline.
Gives you direct or indirect access to change management operations.
Captures definitions of schema objects.
Allows you to easily compare schemas or databases.
Provides focused, performance diagnostics for Oracle sessions.
The following sections provide an overview of these applications.
The following list provides the new features and enhancements to release 9i of the Oracle Standard Management Pack.
Oracle Performance Manager provides a system for capturing, filtering, and presenting performance data for both the database and the host operating system. Oracle Performance Manager offers:
With Oracle Performance Manager, database and host operating system performance statistics are captured in real-time mode and can be viewed in various tables and charts and in two- and three-dimensional presentations.
Oracle Performance Manager provides a large collection of predefined charts and tables organized into performance monitoring groups, including database contention, I/O, load, memory use, instance metrics, parallel server performance, and host operating system resource usage.
Oracle Performance Manager can be used to graphically display any data accessible through SQL or through the data collection framework. The application allows you to create customized charts from user-defined scripts which then can be added to the Oracle Performance Manager navigator tree for easy access.
With Oracle Performance Manager, chart properties and attributes can be customized to change the type of the presentation. The type of chart can be changed to bar, hierarchical, strip, pie, or table.
Allows charts to be linked to other charts to gather detailed information.
A user can capture a chart's activity for analysis at a later date. Oracle Performance Manager allows charts to be recorded and played back at your convenience.
The Oracle Index Tuning wizard quickly finds indexing problems that can slow down the performance of your Oracle8 database. You can use the Index Tuning wizard to evaluate and optimize indexes for situations when, for example, SQL statement response time is slow.
The Index Tuning wizard considers your application type, for example, data warehousing, table, and SQL statements for tuning.
The Index Tuning wizard then implements the generated recommendations or saves the recommendations for later implementation. Each index recommendation generated contains detailed information on exactly what operation needs to be performed on the schema.
The Change Manager application is the change management central interface. In most cases, Change Manager gives you direct or indirect access to change management operations, such as creating baselines with Create Baseline and comparing database object definitions with Compare Database Objects.
The Create Baseline application guides you through the process of capturing the definitions of a database (or a subset of a database) in a form useful to Compare Database Objects and other applications. Create Baseline lets you specify the set of database object definitions to capture, then captures those definitions in their current state.
Create Baseline can capture object definitions in both of the following forms:
The Baseline Viewer application lets you display baselines created using Create Baseline. Baseline Viewer also allows you to view a particular version of a baseline and to generate SQL statements for a baseline (if the statements were not generated already by Create Baseline when the baseline was created).
The Compare Database Objects application guides you through the steps of selecting two sets of object definitions and then comparing them. The object definitions can be selected from current databases or they can be selected from baselines created earlier with Compare Database Objects. If differences are found when the two sets of object definitions are compared, the Comparison Viewer allows you to view the differences between the corresponding object definitions.
The Oracle TopSessions chart provides a focused view of database activity by database session. Oracle TopSessions extracts and analyzes sample dynamic Oracle performance data by session, automatically determining the top Oracle users based on a specific selection criteria, such as memory, CPU usage, or file I/O activity.