Oracle Enterprise Manager Getting Started with the Oracle Diagnostics Pack
Release 9.0.1

Part Number A88748-02

Home

Book List

Index

Master Index

Feedback

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

What's New in Version 9i
Oracle Advanced Event Tests
Oracle Performance Manager
Oracle Capacity Planner
Oracle Trace Data Viewer
Oracle TopSessions Charts
Typical Scenario for Using the Diagnostics Pack
System Monitoring and Problem Detection
Diagnosing the Cause of the Problem
Examining the Current State of the System
Investigating Resource Usage
Identifying Problem Sessions
Identifying High Impact SQL
Analyzing Past Information
Correcting the Problem
Microsoft SQL Server Support

2 Post-Installation Configuration

Setting Up Advanced Events
Setting Up Capacity Planner and Performance Manager
Configuring Pre-9i Databases to Use Performance Reporting in Capacity Planner
Configuring Oracle Intelligent Agent to Collect Data
Enabling Disk Statistics Collection on Windows NT
Converting User-Defined Charts From Previous Releases of Performance Manager
Converting Performance Manager Release 1.5.0 User-Defined Charts
Converting Performance Manager Release 1.6.0 User-Defined Charts
Using Performance Manager in a Parallel Server Environment
Obtaining Trace Data for Use in Trace Data Viewer

3 Introduction to Oracle Performance Manager

Accessing Performance Data Through an Intermediate Host
Usage Scenarios for Oracle Performance Manager
Starting Oracle Performance Manager
Starting Oracle Performance Manager from the Console
Starting Oracle Performance Manager from the UNIX Command Line
Starting Oracle Performance Manager from the Start Menu in Windows NT
Running Performance Manager in Enterprise Mode
Running Performance Manager in Standalone Mode
Using the Oracle Performance Manager Main Window
Connecting to a Discovered Target in Enterprise Mode
Manually Connecting to a Target
Viewing Performance Manager Charts
Monitoring Multiple Targets Concurrently
Viewing Chart Groups
Selecting Collected Data and Data Sources
Using the Chart Display Window
Selecting a Chart Format
Setting the Chart Refresh Rate
Pausing and Restarting a Chart
Selecting Chart Options
Chart-Specific Commands
Drilling Down from One Chart to Another
Using the Chart Status Button
Drilling Down to an Historical Chart
Displaying Alternate Chart Orientations
Sorting Data in a Table Chart
Saving Your Changes to a Chart
Obtaining Help for a Class, Chart, or Data Item
Printing a Chart
Generating a Report for a Chart
Recording Chart Data
Starting a Recording
Stopping a Recording
Playing a Recording
Removing a Recording
Creating a User-Defined Chart
Modifying an Existing User-Defined Chart
Modifying the Data Items for a User-Defined Chart
Copying a User-Defined Chart
Converting Old Performance Manager User-Defined Charts
Chart Display Window Menu Shortcut Keys
Working With Events and Thresholds in Performance Manager
Triggered Events and Thresholds
Events Registered for Multiple Targets
Metrics with Multiple Events and Different Thresholds
Event Permissions
Registering Events in Performance Manager
About Oracle 9i and Pre-9i Agents
Viewing Thresholds
Resetting Thresholds
Refreshing Thresholds
Editing Threshold Associations
Running Performance Manager in a Browser
Viewing Metric and Event Documentation Through a Browser

4 Introduction to Oracle Capacity Planner

How Capacity Planner Collects and Stores Performance Data
Accessing Historical Data Through an Intermediate Host
Usage Scenarios for Oracle Capacity Planner
Starting Oracle Capacity Planner
Using Help
Using Oracle Capacity Planner
Setting Up a Collection
Selecting Targets
Selecting Targets on Discovered Nodes
Selecting Targets on Undiscovered Nodes
About the Target Property Sheet
Defining the Frequency of Collection Samples
Defining the Location of the Historical Database
Defining the Frequency of Loading Collection Data
Understanding When the Loader Runs
Understanding How Data Aggregation Works
Defining the Amount of Data to Keep
Applying and Reverting the Collection Settings for a Target
Selecting the Classes of Data to Collect
Starting Data Collection
Stopping Data Collection
Generating a Collection Report
Copying Collection Settings
Creating a User-Defined Class
Designating a Data Item as the Data Source for a User-Defined Class
Removing, Modifying, and Adding Data Items in a User-Defined Class
Modifying User-Defined Classes
Creating a User-Defined Class Like an Existing User-Defined Class
Starting Data Collection for a User-Defined Class
Deleting a User-Defined Class
Troubleshooting Collection and Load Problems
Collecting Data for Diagnostic Reporting
Scope of the Oracle Recommended Collection
Collecting for Performance Reporting
Analyzing Collected Data
Connecting to an Oracle Capacity Planner Historical Database
Organization of Data in the Navigator
Browsing the Collected Data
Viewing an Analysis for a Class of Data
Saving a Class Analysis as a User-Defined Analysis
Specifying Selection Criteria for a Class of Data
Viewing and Modifying User-Defined and Predefined Analyses
Creating a Copy of an Analysis
Renaming a User-Defined Analysis
Deleting a User-Defined Analysis
Working with Analyses
Viewing the Value of a Data Point
Selecting a Line
Adding a Class of Data to an Analysis
Modifying Selection Criteria from the Analysis Window
Removing a Line from a Chart
Excluding a Data Point from a Chart
Showing or Hiding the Chart Legend
Zooming and Scrolling to View More or Less Chart Data
Auto-Scaling Data
What Is a Trend Analysis?
Specifying and Performing a Trend Analysis
Saving Changes to a User-Defined or Predefined Analysis
Saving the Results of a User-Defined Analysis
Saving the Results of a Predefined Analysis
Printing an Analysis Chart
Generating a Report for an Analysis Chart
Understanding the Oracle Capacity Planner Historical Database
Understanding the Service Reference Table (vp_service_ref)
Understanding the Class Reference Table (vp_class_ref)
Understanding the Data Tables
Data Table Names
Data Table Contents

5 Oracle e-Business Management Tools

Monitoring Features of the HTTP Servers
Discovering the HTTP Server
Real-Time Monitoring of the HTTP Server
Reporting of HTTP Server Activity
Log Analysis Report Job Task
Contents of Apache Server Access Log Traffic Report
Charts and Chart Groups
Performance Overview Class
I/O Class
Server Utilization Class

6 Using Oracle TopSessions

Overview of Oracle TopSessions
Before You Use the Oracle TopSessions Chart
Displaying the TopSessions Chart
Displaying the TopSessions Chart from the Console
Starting TopSessions from the Start Menu
Displaying TopSessions in Performance Manager
Oracle TopSessions Menu Bar
File Menu
View Menu
Collection Menu
Drilldown Menu
Help Menu
Toolbar
Print Screen
Report Chart
Chart Type
Horizontal Orientation
Vertical Orientation
Refresh Rate
Pause Chart
Resume Chart
Options
Historical Data
Start Recording
Stop Recording
Help on Chart
Overview of Session Activity
Using the Right Mouse Button on the Main Display
Sorting the Order of Entries in the Chart
Using the Chart Status Button
Viewing Details About a Given Session
Session Details Page
Session Details Statistics Page
Customizing the Session Information You Display
Data Options Page
Data Sources
Select Collected Data
Session Filtering Options Page
Creating a Customized TopSessions Collection
Options Page

7 Using Oracle Trace Data Viewer

Overview
Usage Scenarios for Data Viewer
Starting Data Viewer
Starting Data Viewer from Oracle Enterprise Manager
Starting Data Viewer from the Start Menu
Using Data Viewer
Computing Statistics - Preparing Data for Fast Access and Analysis
Displaying Data Views
Accessing the Definition of a Data View
Viewing Data in a Data View
Creating Custom Data Views
Modifying or Extending Data Views
Drill-Down of Data Views
Selecting a Drill-Down Data View
Modifying Drill-Down Data Views
Saving As Data Views and Files
Printing Data Views
Using the Data View Wizard
Choosing an Event
Choosing Items Associated with the Selected Event
Choosing the Sort Criteria
Defining the Number of Rows to Display
Reviewing the Summary Page
Data Viewer Problems
Could Not View Oracle Trace Formatted Data
Need to Restore Formatted Data
Additional Formatted Data Is Missing from Data Viewer
Poor Performance
Table or View Does Not Exist (or No Data in Collection)
Isolating an Oracle Trace Problem
Isolating a Problem in Oracle Trace Collection Services
Oracle Trace Command-Line Interface
Oracle7 Stored Procedures
EPC_ERROR.LOG File
Information Needed When Reporting a Problem

A Using Advanced Event Tests Effectively

Operational Management
Problem
Action
Resolution
Space Management
Problem
Action
Resolution
Performance Tuning
Problem
Action
Resolution

Index


Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Index

Master Index

Feedback