3 Licensable Management Features

Automatic Workload Repository (AWR)

Provide Oracle Database 10g built-in, automatic capture of statistics data to be used for real-time and historical performance analysis. Snapshot data, active session history data, and workload reports are part of AWR.

Performance monitoring and diagnostics

Measure performance and diagnoses poor performance with associated drill-downs on the Performance page. This includes historical analysis and alert threshold integration.

Automatic Database Diagnostic Monitor (ADDM)

Provide Oracle Database 10g built-in functionality for out-of-the-box automatic performance analysis based on AWR data.

Operating system monitoring

Monitor the operating system and hardware in the drill-downs from Grid Control host monitoring pages.

Adaptive metric thresholds

Capture "baselines" of workload performance metrics during "normal" performance and compares against the same metrics during poor performance to diagnose the causes.

Set adaptive thresholds using a pre-defined baseline to accurately detect alert conditions when a system has predictably varying workloads.

Advanced alert management

Include notification methods, rules, and schedules, metric history and associated drill-downs, ability to set blackouts, associate corrective actions with an alert, user-defined metrics, metric snapshots, monitoring templates, adaptive metric thresholds, setting metric baselines, and Memory Access Mode.

Memory access mode

For slow or hung systems, retrieve performance statistics directly from the Shared Global Area (SGA), which avoids the computation associated with parsing and executing SQL statements. This remediates severe cases of library cache contention that can prevent the instance from being monitored in SQL Mode.

SQL Tuning Advisor

Include the ability to analyze SQL statements and make recommendations for better execution, such as applying SQL Profiles or recommending rewriting of the SQL.

SQL Access Advisor

Recommend schema changes needed to improve database performance; for example, creation of new indexes and materialized views.

Reorganize objects

Provide the Schema Object Reorganization wizard to reorganize database objects.

SQL Tuning Sets

A SQL Tuning Set (STS) is a database object that captures and manages SQL workloads. It includes one or more SQL statements along with associated execution context (that is, user schema, list of bind values, and so forth) and execution statistics (that is, elapsed time, CPU time, and so forth).

Baselines

Capture database and schema definitions.

Comparisons

Compare baseline with database, or database with database, schema with schema.

Synchronization

Propagate database objects with or without data, and updates database object definitions.

Configuration management

Provide hardware and software configuration data collection, search, comparison, change tracking, and analytical reporting.

Patching

Include Critical Patch Advisories, which alert you to critical patches that need to be applied.

Policy and security management

• Ensure consistency of deployments, system security, and adherence to operation standards.

• Include policy violation notifications and Enterprise Security Advisor.

Policy groups

Provide structured collection of security configuration rules against which targets can be measured or judged. This release provides the following out-of-box policy groups:

• Secure configuration for the Oracle Database

• Secure configuration for the Oracle Listener

• Secure configuration for Oracle Real Application Clusters

This feature is accessible from the Policy Group sub-tab under the Compliance tab.

Patching

• Provide end-to-end patching of Oracle products across a wide-range of product patches and customer environments.

• Provide automated Linux host patching and integration with an Unbreakable Linux network (ULN).

• Generate Critical Patch Advisories that alert you to critical patches that need to be applied. The Critical Patch Facility helps you automate the downloading and deployment of patches.

• Provide Solaris and Windows patching.

• Provide patching reports.

Provisioning and Cloning

• Create and maintain a library of reference software images.

• Deploy operating systems and software to bare metal servers.

• Provide a provisions standard, or "gold," images of Oracle Database, Oracle Real Application Clusters (RAC), and Oracle Application Server.

• Extend RAC clusters or Oracle Application Server middleware.

• Provide out-of-box and custom reporting on provisioning and deployments.

• Clone databases and Oracle homes.

• Convert single-instance databases to RAC.

Policy and security management

• Ensure consistency of deployments, system security, and adherence to operation standards.

• Include policy violation notifications and Enterprise Security Advisor.

Standby database creation

• Automate the error-prone task of data guard standby database creation.

Define format libraries

Define and use standard mask formats for sensitive data across databases.

Create or use masking definitions

Specify which tables and columns are to be masked as well as the formats used to mask columns.

Export or import application masking templates

Allows application developers or application providers to provide database administrators with a ready-to-use mask definition in a portable XML format.

Export or import format libraries

Allows application developers or information security analysts to provide a ready-to-use definition for common sensitive data that database administrators can reference when specifying a mask definition.

Quick deployment without requiring application code changes

• Quick time to value.

• Any administrator can identify the root cause of a performance problem. No application knowledge is required.

Low overhead monitoring and diagnostics

• Diagnose problems in production.

• No need to reproduce problems in a test or development environment.

Real-time monitoring of JVM

• Summary view of resource bottlenecks affecting performance, such as the database, I/O, CPU, and locks.

Trace in-flight transactions

• View request performance problems in real time.

• Analyze time spent in each resource bottleneck (extend to each Java method).

Memory leak detection and analysis

• Memory leak analysis in production.

• Neither developers nor development tools are required to analyze memory leaks.

• Unnecessary to reproduce problems in a test environment.

Request performance

• Historical views show the response times for end-user requests.

• Response time breakdowns are available in each layer (servlet, JSP, EJB, JDBC and SQL) of an OC4J container.

Interactive transaction trace

• Play a transaction interactively from the browser and view the response time profile.

• View the time spent in the network and server.

• View the response time breakdowns in each layer (servlet, JSP, EJB, JDBC and SQL) of an OC4J container.

System monitoring

• Monitor Application servers and all the components proactively.

• See events and notification on all performance, load, and usage metrics.

• See reports and historical trends.

Quick deployment

No restarts are required.

Immediate visibility into the Java stack

No application instrumentation is required, which provides in-depth method-level visibility into all active transactions occurring in JVM.

Identifies the slowest requests

Identify the slowest requests, slowest methods and the bottleneck resources such as CPU, I/O, memory, slow running or hanging threads, and Oracle Database.

Detects memory leaks

Enable administrators to perform memory leak analysis in a production environment without stopping the application. Administrators can take multiple heap snapshots over a period of time and compare them to find the Java objects leaking memory.

Traces Java requests

Trace Java requests to the associated database sessions. It highlights the slowest SQL queries and help administrators to tune SQL and the database to improve the performance application. This facilitates smooth communication between the database administrators and application administrators by isolating the problems to the database or Java code.

Configuration management

Collect, search, compare, track changes, and analytically report hardware and software configuration data.

Patch advisories

Receive alerts to critical patches that need to be applied, including Critical Patch Advisories.

Policy and security management

• Ensure consistency of deployments, system security, and adherence to operation standards.

• Receive policy violation notifications, including Enterprise Security Advisories.

Patching

• Provide end-to-end patching of the Oracle Application Server across a wide-range of product patches and customer environments.

• Provide automated Linux, Solaris, and Windows host patching and integration with an Unbreakable Linux network (ULN).

• Receive alerts to critical patches that need to be applied through Critical Patch Advisories, and automate the downloading and deployment of patches through the Critical Patch Facility.

Provisioning

• Create and maintain a library of reference software images.

• Deploy operating systems and Oracle Application Server software to bare metal servers.

• Create a provisions standard, or "gold" image of Oracle Application Server software.

• Extend Oracle Application Server DCM Managed Clusters.

• Leverage out-of-box and custom reporting on provisioning and deployments.

Cloning

• Clone Oracle Application Server Oracle homes.

• Clone Application Server, BPEL, and SOA applications.

Policy and security management

• Ensure consistency of deployments, system security, and adherence to operation security standards.

• Receive notifications for security policies, including Enterprise Security Advisories.

Centralized management console

Provide administrators managing SOA environments with a consolidated browser-based view of the entire enterprise, thereby enabling them to monitor and manage all of their components from a central location.

Discovery and service modeling

Provide discovery of BPEL processes deployed on the Oracle BPEL server and dependent partner links. Service modeling offers out-of-the-box automated system modeling capabilities for the SOA infrastructure.

Runtime governance

Define SOAP tests to measure and record availability and performance of the partner link (or any Web service) for historical trending, troubleshooting, and root cause analysis purposes. Also provides an error hospital of process instances with drilldowns into instance details.

Infrastructure management

Monitor the availability and performance of the SOA infrastructure components. Both current and historic availability of targets (such as BPEL PM server) are recorded for troubleshooting and root cause analysis.

Configuration management

Collect configuration information for the BPEL Process Manager server, domains, and processes. The Process Manager server and domain parameters can be refreshed, saved, or compared with another target. Different versions of the same BPEL process can also be compared.

Deployment automation

Automate the deployment of one or more BPEL suitcases to one or more BPEL targets. Scheduling capability is also provided.

Adapter metrics

Throughput and error metrics for different adapters are provided in graphical format.

Business-IT alignment

Enable enterprises to consolidate their IT and business management tools into a unified system. BAM-EM integration unites business KPIs and system metrics in one system for correlation and trending.

Service level management

Enable administrators to monitor services from the end-user's perspective using service tests or synthetic transactions, model relationships between services and underlying IT components, and report on achieved service levels.

Historical analysis and reporting

Store the collected metric and configuration data in a central repository, thereby enabling administrators to analyze metrics through various historical views and facilitate strategic trend analysis and reporting.

Configuration management

Collect, search, compare, track changes, and analytically report hardware and software configuration data.

Policy management

Ensure consistency of deployments and adherence to operation standards. Includes policy violation notifications.

Quick deployment without requiring application code changes

• Quick time to value.

• Any administrator can identify the root cause of a performance problem. No application knowledge is required.

Low overhead monitoring and diagnostics

• Diagnose problems in production.

• No need to reproduce problems in a test or development environment.

Real-time monitoring of JVM

• Summary view of resource bottlenecks affecting performance, such as the database, I/O, CPU, and locks.

Trace in-flight transactions

• View request performance problems in real time.

• Analyze time spent in each resource bottleneck (extend to each Java method).

Memory leak detection and analysis

• Memory leak analysis in production.

• Neither developers nor development tools are required to analyze memory leaks.

• Unnecessary to reproduce problems in a test environment.

System monitoring

• Monitor Application servers and all the components proactively.

• See events and notification on all performance, load, and usage metrics.

• See reports and historical trends.

Patching

• Provide end-to-end patching of Oracle products across a wide-range of product patches and customer environments.

• Provide automated Linux, Solaris, and Windows host patching and integration with an Unbreakable Linux network (ULN).

• Critical Patch Advisories alert you to critical patches that need to be applied, and the Critical Patch Facility helps you automate the downloading and deployment of patches.

Provisioning

• Create and maintain a library of reference software images.

• Deploy operating systems and software to bare metal servers.

• Provide a provisions standard, or "gold," images of Oracle Database, Oracle Real Application Clusters (RAC), and Oracle Application Server.

• Extend RAC clusters or Oracle Application Server middleware.

• Provide out-of-box and custom reporting on provisioning and deployments.

Cloning

• Clone databases and Oracle homes.

• Convert single-instance databases to RAC.

• Clone Application Server, BPEL, and SOA applications.

• Clone an entire E-Business Suite environment from test to production.

Policy and security management

• Ensure consistency of deployments, system security, and adherence to operation standards.

• Include policy violation notifications and Enterprise Security Advisor.

Standby database creation

• Automate the error-prone task of data guard standby database creation.

Performance monitoring

Provide real-time and historical performance monitoring. Reduces the complex tasks of diagnosing and correcting performance problems for your targets.

Advanced alert Management

Provide notification methods, rules, and schedules, metric history and associated drill-downs, ability to set blackouts, associate corrective actions with an alert, user-defined metrics, metric snapshots, and monitoring templates.

Configuration management

Provide configuration data collection, search, comparison, and historical change tracking.

Task automation

Automate common administrative functions across one or several targets through the Job System.

Groups and systems

Collectively manage several distributed targets as easily as a single component.

Automatic discovery

• Discover PeopleSoft Enterprise components.

• Create a system with all of the associated infrastructure components.

Monitoring and diagnostics

• Receive real-time metrics, Tuxedo queues, and historical data as well as alert notifications.

• Examine log files for information pertinent to identifying problem root causes.

Configuration management

Ability to:

• Track configuration parameters.

• Take configuration snapshots.

• Compare configurations.

Service level management

Monitor PeopleSoft Enterprise applications using beacon transactions and service dashboards.

Administration

• Start and stops PeopleSoft components.

• Define PeopleSoft domains.

• Clear cache.

Automatic discovery

• Discover Siebel components.

• Create system and services targets with all of the associated infrastructure components.

Monitoring and diagnostics

• Receive real-time metrics and historical data as well as alert notifications.

• Examine log files for information pertinent to identifying problem root causes.

• Analyze SARM data to identify transaction bottlenecks.

Configuration management

Ability to:

• Track configuration parameters.

• Take configuration snapshots.

• Compare configurations.

Service level management

Monitor Siebel applications using beacon transactions and service dashboards.

Administration

Start and stop the Siebel Server and server components.

Automatic discovery

• Discover Oracle E-Business Suite components.

• Create system and services targets with all of the associated infrastructure components.

Monitoring and diagnostics

• Receive real-time metrics and historical data as well as alert notifications.

• Access JVM statistics.

• Run E-Business Suite diagnostic tests through OAM integration.

Configuration management

Ability to:

• Track configuration parameters.

• Take configuration snapshots.

• Compare configurations.

Service level management

Monitor Oracle E-Business Suite applications using beacon transactions and service dashboards.

Cloning

• Automate cloning of Oracle E-Business Suite environments via a web-based tool.

• Created and manage clone images.

• Scramble sensitive business data.