Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

How this Guide Is Organized

Documentation Set

Related Documents

Conventions

Documentation Accessibility

1 Overview of Oracle Enterprise Manager

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

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

Complex Jobs

Scalability

Security and Jobs

Event System

Proactive Event Management

Scalability

Event Notification and Filtering

Event Log

Unsolicited Error Detection

Event Handler

4 Database Administration

Common Features of DBA Management Functionality

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

DBA Management Functionality and Wizards

Instance Management

Schema Management

Security Management

Storage Management

Replication Management

Oracle 9i JVM

OLAP Services

Workspace Management

SQL*Plus Worksheet

Wizards

5 Oracle Management Packs and Integrated Applications

Oracle Diagnostics Pack

Oracle Advanced Events

Oracle Performance Manager

Oracle Capacity Planner

Oracle TopSessions

Oracle Trace

e-Business Management Tools

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

Oracle Standard Management Pack

Oracle Management Pack for Oracle Applications

Oracle Management Pack for SAP R/3

Integrated Applications

A Keyboard Navigation

Glossary