Oracle Enterprise Manager. Getting Started with the Oracle Diagnostics Pack

Send Us Your Comments......Page 11
Preface......Page 13
1 Overview......Page 21
What’s New in Version 9i......Page 22
Oracle Advanced Event Tests......Page 23
Oracle Capacity Planner......Page 24
Oracle TopSessions Charts......Page 25
System Monitoring and Problem Detection......Page 26
Identifying Problem Sessions......Page 27
Correcting the Problem......Page 28
Microsoft SQL Server Support......Page 29
Setting Up Advanced Events......Page 31
Configuring Pre-9i Databases to Use Performance Reporting in Capacity Planner......Page 32
Converting User-Defined Charts From Previous Releases of Performance Manager......Page 33
Converting Performance Manager Release 1.5.0 User-Defined Charts......Page 34
Using Performance Manager in a Parallel Server Environment......Page 35
Obtaining Trace Data for Use in Trace Data Viewer......Page 36
3 Introduction to Oracle Performance Manager......Page 37
Accessing Performance Data Through an Intermediate Host......Page 39
Usage Scenarios for Oracle Performance Manager......Page 40
Starting Oracle Performance Manager from the UNIX Command Line......Page 41
Running Performance Manager in Enterprise Mode......Page 42
Using the Oracle Performance Manager Main Window......Page 43
Manually Connecting to a Target......Page 45
Viewing Performance Manager Charts......Page 46
Viewing Chart Groups......Page 47
Selecting Collected Data and Data Sources......Page 48
Selecting a Chart Format......Page 49
Selecting Chart Options......Page 50
Drilling Down from One Chart to Another......Page 52
Using the Chart Status Button......Page 53
Drilling Down to an Historical Chart......Page 55
Saving Your Changes to a Chart......Page 57
Obtaining Help for a Class, Chart, or Data Item......Page 58
Recording Chart Data......Page 59
Playing a Recording......Page 60
Creating a User-Defined Chart......Page 61
Modifying an Existing User-Defined Chart......Page 62
Copying a User-Defined Chart......Page 63
Chart Display Window Menu Shortcut Keys......Page 64
Working With Events and Thresholds in Performance Manager......Page 65
Events Registered for Multiple Targets......Page 68
Registering Events in Performance Manager......Page 69
Viewing Thresholds......Page 70
Resetting Thresholds......Page 72
Editing Threshold Associations......Page 73
Running Performance Manager in a Browser......Page 75
Viewing Metric and Event Documentation Through a Browser......Page 76
4 Introduction to Oracle Capacity Planner......Page 79
How Capacity Planner Collects and Stores Performance Data......Page 80
Accessing Historical Data Through an Intermediate Host......Page 81
Starting Oracle Capacity Planner......Page 82
Using Help......Page 83
Setting Up a Collection......Page 84
Selecting Targets on Discovered Nodes......Page 85
Selecting Targets on Undiscovered Nodes......Page 86
Defining the Frequency of Collection Samples......Page 87
Defining the Location of the Historical Database......Page 88
Defining the Frequency of Loading Collection Data......Page 89
Understanding How Data Aggregation Works......Page 90
Applying and Reverting the Collection Settings for a Target......Page 92
Selecting the Classes of Data to Collect......Page 93
Starting Data Collection......Page 95
Stopping Data Collection......Page 96
Copying Collection Settings......Page 97
Creating a User-Defined Class......Page 98
Designating a Data Item as the Data Source for a User-Defined Class......Page 99
Removing, Modifying, and Adding Data Items in a User-Defined Class......Page 100
Modifying User-Defined Classes......Page 101
Creating a User-Defined Class Like an Existing User-Defined Class......Page 102
Troubleshooting Collection and Load Problems......Page 103
Collecting Data for Diagnostic Reporting......Page 104
Scope of the Oracle Recommended Collection......Page 105
Collecting for Performance Reporting......Page 112
Connecting to an Oracle Capacity Planner Historical Database......Page 113
Organization of Data in the Navigator......Page 114
Viewing an Analysis for a Class of Data......Page 115
Specifying Selection Criteria for a Class of Data......Page 116
Viewing and Modifying User-Defined and Predefined Analyses......Page 117
Creating a Copy of an Analysis......Page 118
Deleting a User-Defined Analysis......Page 119
Viewing the Value of a Data Point......Page 120
Adding a Class of Data to an Analysis......Page 121
Removing a Line from a Chart......Page 122
Showing or Hiding the Chart Legend......Page 123
Zooming and Scrolling to View More or Less Chart Data......Page 124
What Is a Trend Analysis?......Page 125
Specifying and Performing a Trend Analysis......Page 126
Printing an Analysis Chart......Page 128
Understanding the Service Reference Table (vp_service_ref)......Page 129
Data Table Names......Page 130
Data Table Contents......Page 131
Discovering the HTTP Server......Page 133
Real-Time Monitoring of the HTTP Server......Page 134
Contents of Apache Server Access Log Traffic Report......Page 135
Performance Overview Class......Page 137
Server Utilization Class......Page 138
Overview of Oracle TopSessions......Page 141
Before You Use the Oracle TopSessions Chart......Page 142
Starting TopSessions from the Start Menu......Page 143
Displaying TopSessions in Performance Manager......Page 144
Oracle TopSessions Menu Bar......Page 145
Collection Menu......Page 146
Drilldown Menu......Page 147
Report Chart......Page 148
Historical Data......Page 149
Overview of Session Activity......Page 150
Viewing Details About a Given Session......Page 153
Session Details Page......Page 154
Customizing the Session Information You Display......Page 155
Select Collected Data......Page 156
Creating a Customized TopSessions Collection......Page 157
Options Page......Page 158
Overview......Page 161
Starting Data Viewer......Page 162
Starting Data Viewer from the Start Menu......Page 163
Computing Statistics – Preparing Data for Fast Access and Analysis......Page 164
Displaying Data Views......Page 165
Accessing the Definition of a Data View......Page 169
Viewing Data in a Data View......Page 170
Modifying or Extending Data Views......Page 172
Drill-Down of Data Views......Page 173
Selecting a Drill-Down Data View......Page 176
Modifying Drill-Down Data Views......Page 177
Using the Data View Wizard......Page 178
Choosing an Event......Page 179
Choosing Items Associated with the Selected Event......Page 180
Defining the Number of Rows to Display......Page 182
Reviewing the Summary Page......Page 183
Could Not View Oracle Trace Formatted Data......Page 184
Table or View Does Not Exist (or No Data in Collection)......Page 185
Isolating an Oracle Trace Problem......Page 186
Oracle Trace Command-Line Interface......Page 187
Oracle7 Stored Procedures......Page 188
Information Needed When Reporting a Problem......Page 189
A Using Advanced Event Tests Effectively......Page 191
Action......Page 192
Resolution......Page 194
Action......Page 195
Problem......Page 196
Resolution......Page 197
Index......Page 199