Oracle Enterprise Manager Performance Monitoring User's Guide
Library
Product
Preface
Purpose of this Guide
Audience
Knowledge Assumed of the Reader
How this Guide is Organized
Part I: Using Oracle Performance Manager
Part II: Using Other Performance Monitoring Applications
How to Use this Guide
Conventions Used in this Guide
Syntax Diagrams
Examples
Special Icons
Related Publications
Oracle Enterprise Manager Documentation
Other Related Oracle Publications
Your Comments Are Welcome
Chapter 1 Performance Monitoring Applications
Performance Monitoring Overview
Oracle Performance Manager
Oracle Lock Manager
Oracle TopSessions
Oracle Tablespace Manager
Starting Performance Monitoring Applications
Starting from the Console
Starting in Standalone Mode
A Typical Performance Monitoring Scenario
Part I Using Oracle Performance Manager
Chapter 2 Oracle Performance Manager Overview
Terminology
Starting Oracle Performance Manager
Oracle Performance Manager Main Window
Title Bar
Status Bar
Menu Bar
File Menu
Display Menu
Charts Menu
Record Menu
Help Menu
Using the Right Mouse Button
Chart Types
Chapter 3 Using Predefined Charts
Default Features of Predefined Charts
Overview of Predefined Charts
Buffer Cache Hit %
Buffer Gets Rate
Circuit
Data Dict Cache Hit %
Dispatcher
File I/O Rate
File I/O Rate Details
Free List Hit %
Latch
Library Cache Details
Library Cache Hit %
Lock
Memory Allocated
Memory Sort Hit %
Network Bytes Rate
Network I/O Rate
No. of Users Active
No. of Users Logged On
No. of Users Running
No. of Users Waiting
No. of Users Waiting For Locks
Overview
Parse Ratio
Process
Queue
Read Consistency Hit %
Redo Allocation Hit %
Redo Statistics Rate
Rollback Nowait Hit %
Session
Shared Server
Sort Rows Rate
SQL Area
System I/O Rate
System Stats
Table Access
Table Scan Rows Rate
Tablespace
Tablespace Free Space
Throughput Rate
Chapter 4 Customizing Display Elements of Charts
Customizing the Chart Display
Displayed 3DChart
Scaling of a Displayed Chart
Customizing the Chart Legend
Chart Legend Menu
Chart Legend Properties Other than Location
Chapter 5 Defining or Modifying Charts
Defining a New Chart
SQL Statement Page
Display Options Page
Example of Defining a New Chart
Modifying the Basic Definition of a User-defined SQL Chart
Modifying the Basic Definition of a Predefined Chart
Chapter 6 Displaying Charts in Chart Windows
Chart Window Components
Window Menu
Refresh Menu
Defining a New Chart Window
Modifying an Existing Chart Window
Chapter 7 Working with Oracle Performance Manager Data
Saving and Reusing Chart and Chart Window Definitions
How Chart and Chart Window Definitions are Saved
Sharing Chart and Chart Window Definitions
Working with Historical Data
Collection
Display
Formatting with the Standalone Executable
Deleting an Historical Data Collection
Part II Additional Performance Monitoring Applications
Chapter 8 Using Oracle Lock Manager
Before You Start Oracle Lock Manager
Starting Oracle Lock Manager
Oracle Lock Manager Main Window
Title Bar
Toolbar
Status Bar
Menu Bar
File Menu
View Menu
Locks Menu
Help Menu
Main Display
Identifying Waiting Sessions
Chapter 9 Using Oracle TopSessions
Before You Start Oracle TopSessions
Starting Oracle TopSessions
Oracle TopSessions Main Window
Title Bar
Toolbar
Status Bar
Oracle TopSessions Menu Bar
File Menu
View Menu
Sessions Menu
Help Menu
Obtaining an Overview of Session Activity
Using the Right Mouse Button on the Main Display
Sorting the Order of Entries in the Main Display
Viewing Details About a Given Session
Session Details Pages
Session Details General Page
Session Details Statistics Page
Session Details Cursors Page
Displaying an Explain Plan for a User Session
Session Details Locks Page
Session Details Display Refresh Time
Viewing Session Details for Multiple Sessions
Customizing the Session Information You Display
Options Sort Page
Options Refresh Page
Options Count Page
Exiting Oracle TopSessions
Chapter 10 Using Oracle Tablespace Manager
Starting Oracle Tablespace Manager
Oracle Tablespace Manager Main Window
Oracle Tablespace Manager Titlebar
Oracle Tablespace Manager Toolbar
Oracle Tablespace Manager Status Bar
Oracle Tablespace Manager Main Window
Oracle Tablespace Manager Menu Bar
File Menu
View Menu
Tablespace Menu
Help Menu
Obtaining an Overview of Tablespace Storage
Obtaining an Overview of Datafiles in a Tablespace
Monitoring Segments of a Tablespace
Managing Storage in a Tablespace
Defragmenting a Table Segment in a Tablespace
Specifying Advanced Defragmentation Options
Joining Adjacent Free Extents in the Database
Index
[prev]
[next]
[top]
[bottom]
[contents]
[index]
Copyright © 1996, 1997 Oracle Corporation
Last Modified: 11:38am EST, March 17, 1997
