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

Managing Oracle9i Application Server (Oracle9iAS)

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

Complex 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 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

Configuration Operations

Stored Configurations

Sessions List

Sessions Folder

Locks

In-Doubt Transactions

Resource Consumer Groups

Resource Plans

Resource Plan Schedule

Schema Management

Tree List by Schema

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

Replication Management

Oracle 9i JVM

OLAP Services

Workspace Management

SQL*Plus Worksheet

Wizards

Glossary

Index