Oracle Enterprise Manager Concepts Guide Release 2.2 Part Number A85250-01 |
Library | Service | Contents | Index

# 5
Oracle Management Packs and Integrated Applications

Oracle Enterprise Manager's functionality can be extended further by adding one or more optional management packs. Combined with Oracle Enterprise Manager's Console and framework, these specialized application packs offer integrated solutions for monitoring system bottlenecks, optimizing and tuning system performance, managing system changes, and planning for increases in resource utilization of your entire information system environment.

The following optional system management packs are available for use with Oracle Enterprise Manager:

- Oracle Diagnostics Pack

- Oracle Tuning Pack

- Oracle Change Management Pack

- Oracle Standard Management Pack

- Oracle Management Pack for Oracle Applications

- Oracle Management Pack for SAP R/3

Integrated into the Oracle Enterprise Manager Console are the following applications for added value in enterprise management. These applications are included with Oracle Enterprise Manager.

- Oracle Applications Manager

- Oracle Enterprise Security Manager

- Oracle8i interMedia Text

- Oracle Parallel Server Manager

- Oracle Spatial Index Advisor

- Oracle Directory Manager

- Oracle Distributed Access Manager

- Oracle Developer Server Forms Manager

The sections below describe each of the Oracle system management packs and integrated applications.

## Oracle Diagnostics Pack

The Oracle Diagnostics Pack is a useful set of sophisticated, yet easy-to-use tools for managing the health of your system, including automatically detecting problems, diagnosing problems, and planning for the future. By using the tools in Oracle Diagnostics Pack, you can make significant gains in productivity, manageability, and database performance.

Note: In order to use e-Business Management tools for Oracle Enterprise Manger Release 2.2, your system must have the capability to manage Apache and iAS web servers with basic events and limited monitoring and reporting functionality.

The Oracle Diagnostics Pack contains the following applications:

- Oracle Advanced Events

- Oracle Performance Manager

- Oracle Capacity Planner

- Oracle TopSessions

- Oracle Trace

- e-Business Management Tools

### Oracle Advanced Events

In addition to the basic UpDown event tests provided for all services administered in the Enterprise Manager Console, the Diagnostics Pack provides a library of advanced event tests to automatically detect excessive resource use, performance degradation, and other problem situations.

The key to a smooth running system is to resolve problems before they turn into crises. These advanced event tests allow you to focus on the causes of a problem before the symptoms become serious. In addition, with the paging and e-mail support provided by Enterprise Manager, you can be notified of any problems with the system wherever you happen to be.

The Event Management System (EMS) within Oracle Enterprise Manager assists the DBA with automatic problem detection and correction. Using the EMS, the DBA can establish boundary thresholds for warnings and alerts conditions within the network environment for problem monitoring.

The Enterprise Manager base product comes with a set of event tests called Base Event Tests. These event tests consist of UpDown event tests that check whether a database, listener, or node is available. More comprehensive monitoring is available through Advanced Event Tests. These event tests are packaged with the Oracle Diagnostics Pack and are classified under the following categories:

- Database Event Tests

- Listener Event Test

- Microsoft® SQL Server Event Test

- Node Event Tests

- Windows NT (TM) Event Tests

#### Database Event Tests

The Oracle Advanced Event Tests for the database, listener, and node service types are grouped into the following categories:

- Database Audit Management Event Test: The database Auditing Event test (User Audit) allows you to monitor specific database user connections.

- Database Fault Management Event Tests: This category of event tests monitors for server problems that require immediate action.

- Database Performance Management Event Tests: This category of event tests monitors the system for performance problems.

- Database Resource Management Event Tests: This category of event tests tracks possible resource problems.

- Database Space Management Event Tests: This category of event tests tracks possible space problems within the database.

- User Defined SQL Event Test: This event test allows you to define your own SQL script that evaluates an event condition.

#### Listener Event Test

This category of events monitors for catastrophic conditions on the system. Immediate action needs to be taken by the administrator.

#### Microsoft ® SQL Server Event Test

This test checks whether the Microsoft SQL Server being monitored is running.

#### Node Event Tests

The node event tests include the following categories:

- Common Node Event Tests

- Compaq Tru64 Event Tests

- HP-UX Event Tests

- IBM AIX Event Tests

- Solaris Event Tests

- Windows NT (TM) Event Tests

#### Web Server Event Tests

The Oracle e-Business Management Tools Advanced Event tests are provided for lights-out event monitoring and problem detection of the Web Server.

### Oracle Performance Manager

Performance Manager displays performance data in real-time graphical views that can be automatically refreshed at user-defined intervals. Multiple charts and tables can be displayed simultaneously, affording you a multifaceted view of system performance. For example, an Oracle server administrator can monitor resources consumed by the database, the underlying operating system, and other processes running on the node. Some of the predefined overview charts are:

- Free space available on selected disks

- Memory usage on selected nodes

- Cache utilization

- Throughput

Users can further drill down on these charts to see greater detail, and in some cases, drill down to problematic sessions and terminate them. Many other subsystem specific charts are available, giving you a rich set of data to analyze your system from multiple viewpoints.

### Oracle Capacity Planner

The same data collection mechanism used by Performance Manager to sample real-time data is also used to collect historical performance and resource consumption data. The Diagnostics Pack uses Capacity Planner to analyze performance data to help you diagnose problems using historical information and project your future capacity needs.

In Performance Manager, historical data can be gathered for the services you monitor. The collection can be customized, allowing you to select any subset of statistics to collect and the interval at which these statistics should be sampled. The data collection mechanism provides roll up capabilities, where data is automatically aggregated at the end of each hour, day, week, or month. This data collection mechanism also allows you to set up data expiration policies so you can fully control the amount of storage needed for the historical data.

Once the data is gathered, you can use Capacity Planner to chart the historical data for the purposes of identifying trends and predicting future hardware requirements for the system. You can also extrapolate to a particular point in time or work back from a particular target value and find when a specific level of usage is expected to occur. These charts can be customized, allowing you to get the data you need and to view data from multiple sources (for example, CPU and disk) on a single, unified chart.

### Oracle TopSessions

TopSessions is a tool for monitoring how connected sessions use database instance resources in real time. You can obtain an overview of session activity, by displaying the top "n" sessions sorted by a statistic of your choosing. For any given session, you can then drill down for more detail. You can further customize the information you display by specifying manual or automatic data refresh, the rate of automatic refresh, and the number of sessions to display.

In addition to these useful monitoring capabilities, TopSessions provides a methodology for identifying and correcting certain database performance problems.

For example, when sudden file I/O load is detected, you can first identify the sessions contributing most to the problem, and then isolate the executing SQL statements in user applications for those sessions. You can then analyze the SQL explain plans for those SQL statements to determine how best to resolve the problem.

### Oracle Trace

Trace is a general-purpose tracing mechanism that collects data for any software product enabled with Trace Application Programming Interface (API) calls, such as the Oracle server. You can use Trace to collect a wide variety of data, such as performance statistics, diagnostic data, system resource usage, and business transaction details.

The major components of Trace are the Trace Manager and Trace Data Viewer. Trace Manager is a graphical application used to create, schedule and administer Trace collections for products containing Trace API calls. Trace Manager automatically discovers Trace preconfigured products that are installed on all nodes that are known to the Oracle Management Server. By default Trace discovers any Oracle Server release 7.3.3 and higher.

Data Viewer allows you to view formatted data collected by Trace. Data Viewer handles the complex task of extracting data and aggregating key server performance metrics on a large Trace collection. Once you select a Trace collection, you can have Data Viewer compute SQL or Wait statistics or both.

### e-Business Management Tools

The Oracle e-Business Management Tools (hereafter referred to as e-Business Tools) are a set of applications that enable centralized management of the complete e-Business infrastructure including the client, middle-tier Web servers, and database. The e-Business Tools provide seamless monitoring, reporting, and diagnostics of the e-Business middle-tier Web servers.

The following Web server platforms are supported in Enterprise Manager release 2.2:

- Apache HTTP Server version 1.3.9 and higher

- Oracle iAS version 1.0

Release 2.2 of the e-Business Tools focuses on operational management which includes the reporting on, and the monitoring of the Web servers. All the components are controlled from and fully integrated into the Enterprise Manager Console.

#### Monitoring Features of the Web Servers

The monitoring features of the Web servers include:

- Discovery

  Web server targets are recognized on all nodes in the system. The supported Web server targets are the Apache Web server and the Oracle iAS Web Listener.

- Real-time Monitoring

  The middle-tier Web server I/O and Web server processes are monitored in real time. The e-Business Tools advanced event tests are provided for lights-out event monitoring and problem detection of the Web server. The two types of event tests associated with the Web server are the UpDown event test and Threshold event tests. The Web Server UpDown event test checks whether the Web server being monitored is running. The threshold event tests are triggered by user-specified metrics.

#### Reporting of Web Server Activity

The Apache Server Access Log Traffic report provides an overview of the daily, weekly, and monthly statistics of activity on the Web server. Data for this report is extracted from the Apache server log files and is viewed in HTML format.

The Apache server log files can be configured by the administrator to determine their refresh rate. The amount of data displayed in the report is dependent upon the amount of data in the log files.

The Log Analysis Report job task analyzes the access log file for the Web server target and generates a report. The output is an HTML file that contains various statistics.

The Apache Server Access Log Traffic report is divided into the following sub-reports:

- Monthly Activity Report

  This report gives top level details that allow the administrator to view information about the monthly server activity.

- Activity by Day of Week Report

  The data for this report is cumulative and displayed by day of week (for example, Sunday, Monday, and so on) and represents the total amount of traffic on that server for each week day. Administrators can use this report to determine which day of the week receives the most traffic.

- Activity by Hour of Day Report

  This report displays the cumulative data that shows the amount of traffic on the server by hour of the day. Administrators can use this report to see which times of the day are their peak periods.

- Daily Activity Report

  This report shows the total amount of traffic on the server for a particular day.

#### Charts and Chart Groups

This section describes the Web Server charts and chart groups available in Oracle Performance Manager. Some of these charts provide the ability to perform administrative tasks, for example, server utilization.

The Web Server charts are divided into classes. The classes are:

- Performance Overview

  The Performance Overview class provides chart groups that describe high-level activity.

- I/O

  The I/O class provides charts that describe I/O activity.

- Server Utilization

  The Server Utilization class provides charts that describe server activity.

## Oracle Tuning Pack

The Oracle Tuning Pack contains six applications to help users tune all aspects of their database environment; from identifying and correcting problem SQL statements to adjusting the instance parameters for the database.

The Oracle Tuning Pack enables users to proactively tune their database environment. The applications within the Oracle Tuning Pack can be used to:

- Identify and resolve performance problems

- Identify the cause of a problem that has been reported and get advice on the best way to correct it

- Maintain existing performance

- Avoid performance problems by practicing proper maintenance operations

- Identify potential tuning problems before they occur

- Provide tools and methodologies to establish and maintain database performance

Oracle Tuning Pack includes the following applications that cover the complete spectrum of Oracle tuning:

- Oracle Expert

- Oracle Index Tuning Wizard

- Oracle SQL Analyze

- Oracle Tablespace Map

- Reorg Wizard

### Oracle Expert

An essential follow-through to performance monitoring is database tuning. Database tuning ensures that you are getting maximum database performance and maximum use of the system resources supporting your database.

However, because the nature of database tuning is complex, time-consuming, and requires specialized skills and adherence to a structured methodology, database tuning is often dealt with only when unpredictable problems arise instead of on a consistent basis.

Oracle Tuning Pack meets the need of consistent database tuning by providing an automated performance tuning application, Oracle Expert. Oracle Expert can be used on a periodic, proactive basis to discover Oracle tuning opportunities and to create scripts to correct any problems that have been identified.

Oracle Expert provides flexible and focused tuning in three categories:

- Instance tuning, which includes tuning specific key database initialization parameter categories such as the SGA, sort operations, I/O, and parallel query

- Application tuning, which includes optimizing database access methods used by an application, and searching for redundant SQL in the cache (except for case and spacing)

- Structure tuning, which includes evaluating database storage structures for proper placement and sizing, use of temporary objects, and optimal flexible architecture compliance

After collecting tuning data, Oracle Expert stores the data and any other information supplied by the user into the Oracle Expert repository for analysis by the rules inference engine. The patented object-oriented rules inference engine is designed to perform complex database tuning analysis and contains hundreds of rules for tuning an Oracle database. Oracle Expert then evaluates this data, looking for tuning opportunities and produces a set of recommendations for tuning improvements listed in the order of performance gain impact.

If the user accepts Oracle Expert's tuning recommendation, a script is generated to implement the recommendation. Many of the scripts can be implemented immediately or customized by the user. A detailed report of the collected data and the analysis process can also be created on request by the user.

Oracle Expert can also share tuning data with Oracle SQL Analyze, which is another tool in the Oracle Tuning Pack (discussed below). This shared data is stored in Oracle Tuning Pack's SQL History, which stores all data gathered by Oracle Expert and Oracle SQL Analyze. By sharing tuning data, Oracle Expert and Oracle SQL Analyze do not need to gather system data that has already been gathered and stored in SQL History.

### Oracle Index Tuning Wizard

Missing or inappropriate indexes can often cause serious performance problems for an application. To quickly identify and correct index problems, the Oracle Tuning Pack includes a wizard to guide you step-by-step through the process of tuning indexes. The wizard uses the analyzing capabilities and intelligence built into the Oracle Tuning Pack to both recommend optimal indexing strategies and to implement the tuning recommendations.

### Oracle SQL Analyze

Inefficient SQL statements can cause database performance problems in even the best-tuned databases. To complement the database tuning features of Oracle Expert, the Oracle Tuning pack provides Oracle SQL Analyze, an application for analyzing and tuning individual SQL statements.

Oracle SQL Analyze provides a workbench for identifying and tuning problematic SQL statements which are causing the greatest impact on database performance. SQL Analyze identifies the SQL statements executing on the database and evaluates the statements based on user-selected criteria, such as resource usage and I/O's per statement. Once a problem SQL statement is identified, it can be dragged and dropped from the database library cache to the SQL Analyze tuning window for evaluation and tuning.

Under one of two optimizer modes-- cost-based or rule-based--Oracle SQL Analyze examines the SQL statement to determine what the optimal execution path for the statement would be. For statements retrieving data from multiple tables, the optimizer figures out the optimal table join methods, join orders, and access paths based on such factors as available indexes, the order of tables and columns in the statement, and statistics on the cardinality of objects referenced in the statement.

When using the cost-based optimizer to control the execution plan, the user can use SQL "hints". The use of SQL hints can be valuable for specific queries where the developer is aware of details that may not be available to the optimizer.

The SQL statement's execution path is displayed through an explain plan which provides a list of the operations involved in the statement's execution. After generating one or more explain plans for a SQL statement, you can use SQL Analyze to examine the plan, the order of operations, and relevant statistics for objects used in the plan.

Because explain plans can be confusing to interpret, (the hierarchical order of operations listed in the explain plan is not the order of execution) SQL Analyze makes the execution order clear by providing a graphical step-by-step explanation of the statement's operations which the user can walk through. With this step-by-step explanation, the user can see how the statement will execute and what step each operation is performing.

After the explain plan is reviewed and interpreted, the next step is testing the performance of the statement under various optimizer modes. SQL Analyze allows you to easily execute the statement one or more times to measure performance, such as the elapsed time that it takes to perform the query, the CPU time, and the number of logical and physical reads. SQL Analyze also takes advantage of the new query progress monitoring capability of Oracle8i, allowing you to track the progress of a SQL statement executed from SQL Analyze.

All SQL metrics can be displayed for comparison by highlighting the desired SQL object in the navigator. When you select a SQL object, a table of performance metrics for each comparison is displayed for each optimizer. SQL Analyze also provides "split view" screen options which allow side-by-side comparison of two different SQL statements, or two different optimizer modes for the same statement. Comparing explain plans and performance statistics throughout the tuning cycle allows the user to quickly gauge the relative performance of several different approaches for obtaining the same result set.

### Oracle Tablespace Map

Getting the best performance from a database's application SQL requires more than tuning individual SQL statements; it also requires identifying database storage problems. To meet these needs, the Oracle Tuning Pack includes Oracle Tablespace Map, a tool for monitoring tablespace usage.

The Tablespace Map provides a complete picture of the characteristics of all tablespaces associated with a particular Oracle database. These characteristics include analysis status, segment type, segment name, number of extents, and the total size of the extent in blocks. You can display all segments for a tablespace or all segments for a datafile.

The Tablespace Map also provides an allocation map which illustrates the organization of a tablespace's segments. This map displays an overview of the sequential allocation of space for segment extents within a selected tablespace or datafile. Within the tablespace map, it is possible to select an individual extent and see the segment name, the ID of the block in the extent, the ID of the extent, the size (in blocks) of the extent, and the full name and path of the datafile which is the physical location of the extent.

Another key feature of the Tablespace Map is the Tablespace Analysis tool. A Tablespace Analysis can detect potential space management problems. Once a Tablespace Analysis has been performed, a Tablespace Analysis report is created and provides a detailed listing of any detected problems and marks the problematic segments with a warning or alert flag.

### Reorg Wizard

To correct database storage problems, Oracle Tuning Pack provides the Reorg Wizard, which can help you maintain a well performing database by correcting space usage problems. Over time, database performance can be affected by problems such as row chaining and/or migration and index stagnation. The Reorg Wizard can eliminate space problems by reorganizing database space usage and allowing you to change an object's storage settings and location.

The Reorg Wizard gives you three reorganization options:

- Reorganize specific schema objects

- Reorganize an entire tablespace

- Repair migrated rows

The wizard performs reorganizations within the Oracle database and does not use external data handling operations. Reorganizations can be performed within the target tablespace or by temporarily using space in another tablespace.

The Reorg Wizard evaluates the reorganization operations and generates an Impact Report and reorganization script, which can be reviewed prior to execution.

Reorganizations can be performed immediately or can be scheduled at a later time, perhaps during off-peak hours. In either case, the reorganization will be run by an Enterprise Manager job using the Oracle Agent.

Note: The Enterprise Manager Console, Oracle Management Server and Agent are required to perform reorganizations with the Reorg Wizard. The Agent must be running on the same node as the database being reorganized.

Certain database reorganization operations can be time-consuming and will impact the availability of objects being reorganized. Use database object reorganization selectively. For example, tablespace reorganizations can often be avoided by reorganizing only selected tables and indexes.

## Oracle Change Management Pack

An important task of database administrators is preparing for and reacting to change. Because business needs and requirements can change quickly, adjustments and enhancements are often required for business applications and their supporting databases. DBAs need the ability to respond to these changes quickly and effectively.

Oracle Change Management Pack is a set of easy-to-use tools for managing complex changes in the Oracle Server and database objects. While tracking and implementing changes has typically been a very expensive and difficult process, Oracle Change Management Pack greatly reduces the time and costs associated with managing the implications of changing business needs and requirements.

Managing change in an Oracle environment can mean managing the evolution of schema objects and the database environment. Changes to applications can require changes in the definitions of particular objects like tables or triggers. Over the lifetime of a database, changes may need to be made to the characteristics of a tablespace or a set of users. Oracle Change Management Pack can manage all of these types of changes.

With Oracle Change Management Pack, you can track changes by capturing the definitions of a set of database objects and comparing the object definitions in one schema or database to another. You can also compare object definitions in a schema or database to a previously-captured state (baseline) of the same schema or database or compare two baselines.

Change Management Pack also keeps track of versions of baselines, comparisons, and changes. For example, you could capture repeated versions of a baseline for keeping track of an evolving schema like a meta-data backup.

In addition to tracking changes, Oracle Change Management Pack allows you to implement changes. After comparing two sets of object definitions, you can implement changes by synchronizing database definitions with those of a baseline or another database; or you can create one or more object definitions on multiple databases that are copies of the definitions in another database. You can also change object definitions by simply specifying the changes to make.

To make changes, Oracle Change Management Pack generates scripts that are run against database object definitions. When a script is generated, you have the ability to view and edit the script, execute it whenever you like or schedule a time for the script to be executed, and optionally to roll back the changes. Oracle Change Management Pack also provides an impact report which the administrator can evaluate before making the changes.

In the following section, some of the major capabilities of Oracle Change Management Pack are described.

### Change Manager

Change Manager is a central application for managing your work in Oracle Change Management Pack. The tree view on the left of the application's interface displays baselines, comparisons, and plans. With the detail view on the right, you can launch other wizards and tools.

The following functionality can be accessed from Change Manager:

#### Create Baseline

Create Baseline is a wizard that guides you through the process of capturing the definitions of a database (or subset of a database) in the form of a baseline for other Change Management Pack applications to use. The captured definitions can also be stored in a SQL DDL statement for creating definitions in a new database or as input to CASE tools that accept SQL DDL input.

For example, Create Baseline could capture a baseline of the current state of object, schema, or database definitions, then use Compare Database Objects later to compare the baseline to the same object, schema, or database definition.

#### Compare Database Objects

Compare Database Objects is a wizard that guides you through the steps of selecting two sets of object definitions and comparing them. The object definitions can be from current databases or from a baseline created earlier with Create Baseline. The comparisons can be saved and also written to a report.

You can also use Compare Database Objects's Synchronization Wizard to modify one set of definitions to match the other set of definitions (with the exception of baselines, which are read-only).

For example, Compare Database Objects's Synchronization Wizard could be used to synchronize the current schema or database with a previously captured baseline of the schema or database. The resulting effect would be that any changes made to the schema or database since the baseline was captured are rolled back.

#### DB Quick Change

DB Quick Change guides you through the process of making one or more changes (a "quick change") to a single definition of a database object. Multiple changes can be executed as a unit.

#### DB Alter

DB Alter guides you through the process of making changes to one or more object definitions in one or more databases. Multiple changes in a database are executed as a unit.

#### DB Propagate

DB Propagate guides you through the steps of selecting one or more object definitions from a database, then reproducing those definitions in a destination schema within the source database, or in one or more destination databases.

DB Propagate simplifies such tasks as:

- Cloning a set of tables and data to one or more databases or other services

- Reproducing database object definitions for developers to modify in conjunction with enhancements to an application

- Reproducing the enhanced object definitions at the original database after the developers are satisfied with their modifications

- Reproducing a set of object definitions from a development database to a test database and later to multiple production databases

- Reproducing needed object definitions when deploying a new application to multiple production databases

#### Find Database Objects

Find Database Objects is a search capability for specifying or locating objects based on characteristics of their names. For example, if you know that all your test tables contain the string "TEST", and you need to know how many test tables you have, you can search for all tables or objects with names containing that string. Find Database Objects can be used on its own as a search facility, or with other applications in the pack. For example, Find Database Objects can be used when using Create Baseline for specifying that your baseline contain all objects with names containing the string "TEST".

#### Plan Manager

Plan Manager lets you view, edit, and execute plans that you have created in Oracle Change Management Pack.

By using Oracle Change Management Pack to manage change, administrators can respond quickly to new requirements, eliminate errors or loss of data when making changes, minimize downtime, and maximize productivity.

## Oracle Standard Management Pack

Oracle Standard Management Pack is a management pack designed for smaller enterprises that use the Oracle Workgroup Server or Oracle 8i. This pack combines many of the diagnostic, tuning, and change management functionalities of Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Change Management Pack into one easy-to-use application suitable for the smaller business enterprise. Oracle Standard Management Pack monitors and diagnoses problems, tunes high impact indexes, and tracks and compares changes in the Oracle environment.

Oracle Standard Management Pack is comprised of the following applications for managing the Oracle Environment:

- Oracle Performance Manager: Applies real-time, graphical Oracle and host monitoring through an extensive array of customized performance charts.

- Oracle TopSessions: Quickly identifies, diagnoses, and eliminates problematic database sessions.

- Oracle Index Tuning Wizard: Proactively optimizes the indexes in your database environment.

- Oracle Create Baseline: Captures definitions of schema objects, allowing users to easily "reverse engineer" a schema.

- Oracle Compare Database Objects: Allows users to easily compare schemas or databases and object definitions.

- Oracle Advanced Events: This set of additional tests is an extension to the Oracle Enterprise Manager event management system, providing more advanced event monitoring functionality.

## Oracle Management Pack for Oracle Applications

The Oracle Management Pack for Oracle Applications is a set of advanced tools for monitoring and diagnosing your Oracle Applications environment and planning for future resource needs. The pack extends the existing database management capabilities of Oracle Enterprise Manager to the middle-tier application subsystem of Oracle Applications, namely the Concurrent Processing Servers. The pack builds on the Oracle Enterprise Manager host and database management framework and incorporates Oracle Applications within its managed services.

The Management Pack for Oracle Applications includes the following diagnostic applications for optimum Oracle Applications management:

- Oracle Performance Manager: With the pack's performance management capabilities, it can recognize multiple instances of Oracle Applications and display real-time data of Concurrent Processing Servers and Forms Servers in easy-to-interpret, consolidated graphical views.

- Oracle Capacity Planner: The pack's capacity planning feature collects historical performance data from Concurrent Processing Servers, Forms Servers, and their underlying hosts, allowing correlation and trending of this information for determining future resource requirements.

- Concurrent Processing Tuning Assistant: This feature analyzes historical batch job execution records and identifies scheduling bottlenecks as well as programs that would benefit the most from tuning.

- Oracle Applications Advanced Events: This extension to the Oracle Enterprise Manager event management system allows lights-out event monitoring and problem detection of the entire applications system.

The Management Pack for Oracle Applications displays Concurrent Processing Servers on the Oracle Enterprise Manager Console. The Console provides central administration of a distributed application system, allowing administrators to notify each other if any of the servers go down, and schedule jobs and monitor events on the application subsystems.

## Oracle Management Pack for SAP R/3

Oracle Management Pack for SAP R/3 is a set of applications for monitoring, diagnosing, and planning in the SAP R/3 environment. This pack extends the advanced tools in Oracle Enterprise Manager for monitoring the SAP R/3 environment, diagnosing problems, and planning for future needs.

The Management Pack for SAP R/3 builds on the Oracle Enterprise Manager host and database management framework, and manages the SAP R/3 system as one of its managed services. The pack displays R/3 application servers in the navigator and map views. Jobs and events, including Management Pack for SAP R/3 Advanced Events, are similarly integrated.

Oracle Management Pack for SAP R/3 contains the following applications:

Oracle Performance Manager: This tool recognizes multiple instances of R/3 and displays real-time data of R/3 application servers, buffers, and work processes in an easy-to-interpret, consolidated graphical view.

Oracle Capacity Planner: This tool collects R/3 metrics and diagnoses problems through correlation and trending of the collected information to determine future resource requirements.

Oracle Advanced Events: This extension to the Oracle Enterprise Manager event management system allows lights-out event monitoring and problem detection of the entire R/3 applications system.

## Integrated Applications

The applications listed below are integrated with Oracle Enterprise Manager for added value in managing your Oracle environment, and can be installed with Oracle Enterprise Manager if your environment requires them. The applications can be accessed from the Oracle Enterprise Manager Navigator pane and/or the Console application drawers, or from your operating system.

#### Oracle Applications Manager

Oracle Applications Manager is a tool that provides administrative and diagnostic capabilities for concurrent processing in Oracle Applications. The Oracle Applications Manager Console provides a single point of administration for concurrent managers and requests on multiple Oracle Applications instances.

Using the Console, you can monitor the status of all concurrent managers in an Oracle Applications instance, as well as details for all processes and requests. You can start and stop managers, cancel or put holds on requests that have not yet run, and define new managers.

#### Oracle Enterprise Security Manager

Oracle Enterprise Security Manager is a component of the Oracle Advanced Security Option and manages Oracle8i Enterprise User Security. The application allows administrators to manage enterprise-level role authorization among multiple databases simultaneously.

Enterprise Users are created and centrally managed in an LDAP Directory Server. They use digital certificates and Secure Sockets Layer (SSL) to achieve Single Sign-On to multiple Oracle8i Database Servers. Upon authenticating an Enterprise User, Oracle8i will search for its role authorizations in the Directory. Such role authorizations are known as, "Enterprise Roles".

Enterprise Security Manager allows multiple administrators to define "Enterprise Domains" of servers that share a common set of Enterprise Roles. The tool also allows administrators to create Enterprise Users and then manage their Enterprise Roles within these domains. All information on Enterprise Domains, Databases, Enterprise Roles, and Enterprise Users is stored securely in a Directory, for example Oracle Internet Directory.

#### Oracle8i interMedia Text

The Oracle8i interMedia Text application (the text-management component of the Oracle interMedia product) is a text-search system for managing and searching for text in the Oracle database. This application helps you manage and search for text in the database as quickly and easily as any other type of data. Oracle interMedia Text's search techniques make text a standard datatype in the Oracle server which you can create, modify, and delete. Additionally, with Oracle8i interMedia text, new text-based developments or extensions to existing applications are easy and cost-effective to build with standard SQL tools.

With Oracle8i interMedia Text, you can search for data in any Oracle database application that uses text from search-enabling a comments field in an existing application to implementing large-scale document management systems dealing with multiple document formats and complex search criteria. Oracle8i interMedia Text also supports basic full-text searches in most languages supported by the Oracle database.

Oracle8i interMedia Text allows the database administrator to create and manage interMedia Text indexes used for text querying. Text servers, which poll for new documents not yet indexed can also be started when connecting to a database through the Oracle Management Server.

#### Oracle Parallel Server Manager

Oracle Parallel Server Manager enables the administration of databases that use the Oracle Parallel Server option. Once discovered, Parallel Server Databases appear in the Databases folder of the Console's navigator panel alongside single-instance databases.

Parallel Servers behave similarly to single-instance databases, allowing the full power of the Schema, Security and Storage applications to be applied to parallel server databases. The database administrator can start up, shut down, or check the status of parallel server databases, as well as see the status of parallel servers and the progress of parallel server operations by node and service.

Parallel server startup and shutdown job tasks allow parallel servers to be started and stopped as part of scheduled jobs. Database job tasks, such as Run DBA Script, can be executed on parallel server instances. All database event tests can be registered on parallel server instances.

#### Oracle Spatial Index Advisor

Oracle Spatial Index Advisor helps you analyze and tune spatial indexes on data. Using this application, you can analyze the effectiveness of spatial indexes defined on spatial data. The Advisor lets you see if indexes are properly defined for optimum query performance. The application also provides an understanding of the distribution of data through visual inspection.

A spatial index is a set of database tiles. With Oracle Spatial Index Advisor, the database administrator specifies the size and number of tiles in a database. The geometric coverage of the tiles has a direct impact on query performance. The Advisor allows the user to see the interaction of the tiles with the geometric coverage and to issue queries against the data to see how typical queries will perform.

#### Oracle Directory Manager

Oracle Directory Manager is a Java-based tool for administering most functional areas of Oracle Internet Directory and its related processes. Using Oracle Directory Manager, you can connect to directory servers; manage configuration parameters; add, modify, and delete entries, attributes, and object classes; set up access control policies; configure security; and view and modify replication agreements.

#### Oracle Distributed Access Manager

Oracle Distributed Access Manager is a tool for monitoring and administering Oracle's heterogeneous distributed environments. Non-Oracle systems, such as Sybase, Informix, DB2, and SQL Server are transparently integrated into an Oracle distributed environment using Oracle's transparent gateway technology (i.e., Heterogeneous Services).

Distributed Access Manager monitors gateways configured for non-Oracle systems. It displays all the gateway instances that have been registered with the database to which the tool is connected. For active gateway instances the user can browse the details of each gateway session.

For each active gateway session, Distributed Access Manager provides the name of the Oracle client session that created the gateway connection, the name and location of the gateway process, and the list of gateway initialization parameters used to modify the gateway behavior.

#### Oracle Developer Server Forms Manager

Oracle Developer Server Forms Manager allows you to control and monitor Forms Listener, Forms Server, Load Balancer Server, and Load Balancer Client. The tool provides the following functionality:

- Automatic node discovery, which helps find the Forms listener, Metrics Server, and Metrics client running on the node you want to discover.

- Forms Server listener control, which allows you to remotely create, start, stop, and refresh Forms listener, as well as modify the configuration and list the runtime processes

- Forms Server runtime control, which displays information about the users currently connected

- Load Balancer Control, which helps you remotely create, start, stop, and load the balancer

- Activity monitoring, which allows you to schedule a job while particular events are occurring, such as listener down, CPU usage consumption, and excessive memory usage

- Fixit jobs, which can be used to restart the forms listener automatically if it stops for abnormal reasons

- Notification capability, which allows administrators to be notified by email or pager when a particular event occurs

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index