Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Organization

Related Documents

Conventions

1 Overview of Oracle Enterprise Manager

Managing Your Entire Oracle Environment

Three-Tier Framework

Clients

Oracle Management Server

Managed Nodes

Benefits of Oracle Enterprise Manager

Single Point of Management

Multi-Administrator System

Scalability for Growing, Distributed Environments

Extensible Architecture

Automated Lights-out Administration

Autonomous Intelligent Agent

Database Administration Functionality

Ease of Use

Common Services

Target Discovery

Job System

Event System

Notification System and Filtering

Paging/E-mail Blackouts

Security

Comprehensive Reporting

Font Control

2 The Console

Console Graphical User Interface

Console Views

Navigator

Groups

Jobs

Events

3 Job and Event Systems

Job System

Pre-defined System Tasks

Job Scheduling

Lights-out Management

Cross-Platform Job Scripts

Job Progress

Job Notification and Filtering

Communication with the Intelligent Agent

Composite Jobs

Scalability

Security and Jobs

Event System

Proactive Event Management

Scalability

Event Notification and Filtering

Event Notification

Extended Event Status

Event Colors and Icons

Event Log

Unsolicited Error Detection

Event Handler

4 Database Administration

Common Features of Database Management Features

Tree Views

General Information about Databases

Comprehensive Overview Pages

Property Sheets

Multi-Column Lists

Database Version Awareness

Database Reports

Logging of Database Changes

Showing Object DDL

Show SQL

Show Dependencies

Right-Mouse Commands

DB Search Capabilities

Database Management Features and Wizards

Instance Management

Configuration Operations

General Page

Memory Page

Recovery Page

Resource Monitors Page

Undo Page

Stored Configurations

Sessions List

Sessions Folder

Long Running Operations

Locks

In-Doubt Transactions

Resource Consumer Groups

Resource Plans

Resource Plan Schedule

Schema Management

Tree List by Schema or Object

Editing an Object

Creating Objects

Security Management

User Operations

Role Operations

Profile Operations

Storage Management

Controlfile Operations

Tablespace Operations

Datafile Operations

Rollback Segment Operations

Redo Log Group Operations

Archive Log Operations

Distributed Management

Warehouse Management

OLAP Management

Summary Management

Workspace Management

XML Database

SQL*Plus Worksheet

SQL Scratchpad

Wizards

5 Oracle Management Packs and Integrated Applications

Oracle Diagnostics Pack

Oracle Advanced Events

Database Event Tests

Listener Event Test

Microsoft ® SQL Server Event Test

Node Event Tests

HTTP Server Event Tests

Oracle Performance Manager

Oracle Capacity Planner

Oracle TopSessions

Oracle Trace

Oracle Tuning Pack

Oracle Expert

Oracle Index Tuning Wizard

Oracle SQL Analyze

Oracle Tablespace Map

Reorg Wizard

Outline Management

Outline Editor

Oracle Change Management Pack

Change Manager

Create Baseline

Compare Database Objects

Synchronization Wizard

DB Quick Change

DB Alter

DB Propagate

Plan Editor

Oracle Standard Management Pack

Oracle Management Pack for Oracle Applications

Oracle Management Pack for SAP R/3

Integrated Applications

Oracle Enterprise Security Manager

Oracle9i Text

Oracle Spatial Index Advisor

Oracle Directory Manager

Oracle Forms Server Manager

Oracle Policy Manager

Oracle Net Manager

Oracle Data Guard Manager

Oracle LogMiner Viewer

Glossary

Index