Release 1.4.0
A53699_01
 Library |
 Product |
 Contents |
 Index |
| Oracle Enterprise Manager Performance Monitoring User's Guide Release 1.4.0 A53699_01 |
|
This chapter covers how you use Oracle Performance Manager, including the following topics:
Oracle Performance Manager uses the term "chart" to refer to a graph, and the term "chart window" to refer to the frame window containing one or more charts. When you create a new chart, a new chart window containing that chart is automatically created also. For more information on creating charts, see "Defining or Modifying Charts".
To start Oracle Performance Manager from the Oracle Enterprise Manager Console, see "Starting from the Console".
To start Oracle Performance Manager in standalone mode, perform the following steps:
After you complete the Login Information dialog box, if the Console is not running, the Repository Login dialog box displays. The Repository Login dialog box allows you to choose the repository from which you will load user-defined charts and chart windows that you created in previous sessions for use during this session. This repository will also serve as the location for saving new or modified chart and chart window definitions from this Oracle Performance Manager session. The Repository Login dialog box includes the same fields as does the Login Information dialog box.
The Oracle Performance Manager main window displays, the repository connection is made, and any user-defined charts and chart windows in that repository are automatically loaded for your use during this Oracle Performance Manager session.
After the Oracle Performance Manager is started, its main window appears. Figure 2-1 illustrates the Oracle Performance Manager main window.
As Figure 2-1 shows, the Oracle Performance Manager main window includes a:
| Note:
For information on the components of an Oracle Performance Manager chart window, see "Chart Window Components". |
As with other Oracle Enterprise Manager applications, the Oracle Performance Manager title bar includes the name of the application and the database instance to which a connection has been made.
The Oracle Performance Manager status bar includes an explanation of any selected menu item.
The following section describes the Oracle Performance Manager menu bar.
The Oracle Performance Manager menu bar includes the following pull-down menus:
The File menu items allow you to load user-defined charts and chart windows for use in the current Oracle Performance Manager session, save user-defined charts and chart windows for use in subsequent Oracle Performance Manager sessions, change monitored database and repository connections, choose a machine on which to monitor MIB variables, set up your printing environment, and exit your current Oracle Performance Manager session.
The File menu includes the following menu items:
Allows you to access charts and chart windows defined or modified from previous sessions.
Because choosing Load Charts overwrites any new or modified chart or chart window definitions not yet saved during the current Oracle Performance Manager session, you can use Load Charts as a convenient way to discard chart or chart window definitions you created or modified during the current Oracle Performance Manager session, but no longer want.
For more information, see "Saving and Reusing Chart and Chart Window Definitions".
Allows you to save to the current Oracle Performance Manager repository the user-defined charts and chart windows you have defined or modified during the current Oracle Performance Manager session for reuse in the future. Any changes you have made to predefined charts, such as modifying the data polling interval, will not be saved.
| Attention:
Choosing Save Charts overwrites the chart and chart window definitions that were previously saved using the Save Charts menu item. |
The Save Charts menu item is disabled when no user-defined charts or chart windows have been created, modified, or loaded during this Oracle Performance Manager session.
For more information, see "Saving and Reusing Chart and Chart Window Definitions".
If a connection to a monitored database has already been made, choosing this menu item displays a prompt asking if you want to drop the current connection and close all active windows. If you choose to do so, the Login Information dialog box appears so that you can connect to a database instance and open an Oracle Performance Manager main window to monitor that database. For information on the Login Information dialog box, see "Starting Performance Monitoring Applications".
If no database connection currently exists, choosing this menu item immediately displays the Login Information dialog box.
Allows you to connect to a repository. For more information, see "Saving and Reusing Chart and Chart Window Definitions".
Displays the Print Setup dialog box, from which you can select a printer to print your charts or chart windows, select a remote network in order to access a remote printer, and modify other properties of the print job. (The Print menu item itself is located on the Window menu of each chart window, as described in "Displaying Charts in Chart Windows".
Allows you to exit Oracle Performance Manager. If you launched Oracle Performance Manager from the Console, you return to the Console.
The Display menu items allow you to display chart windows containing charts. For more information on the predefined charts listed in this section, see "Using Predefined Charts".
The Display menu includes the following menu items:
Allows you to display predefined charts for monitoring database contention statistics.
Options include: Circuit; Dispatcher; Free List Hit %; Latch; Lock; Queue; Redo Allocation Hit %; Rollback NoWait Hit %; and Shared Server.
Allows you to display charts for monitoring usage statistics regarding the database instance.
Options include: Process; Session; System Statistics; Table Access; Tablespace; Tablespace Free Space; # Users Active; # Users Logged On; # Users Waiting; # Users Waiting for Locks; and # Users Running.
Allows you to display charts for monitoring input/output activity of the database instance.
Options include: File I/O Rate; File I/O Rate Details; Network I/O Rate; and System I/O Rate.
Allows you to display charts for monitoring the activity level of the database instance.
Options include: Buffer Gets Rate; Network Bytes Rate; Redo Statistics Rate; Sort Rows Rate; Table Scan Rows Rate; and Throughput Rate.
Allows you to display charts for monitoring memory usage of the database instance.
Options include: Buffer Cache Hit %; Data Dict Cache Hit %; Library Cache Hit %; Library Cache Details; SQL Area; Memory Allocated; Memory Sort Hit %; Parse Ratio; and Read Consistency Hit %.
Allows you to display a composite of the following charts: # Users Active; # Users Logged On; # Users Running; # Users Waiting for Locks; Buffer Cache Hit; Data Dict Cache Hit %; File I/O Rate; Library Cache Hit %; Memory Allocated; Memory Sort Hit %; Rollback Nowait Hit %; System I/O Rate; and Throughput.
Displays the Select User-defined Window dialog box, from which you can choose to display a chart window you have already defined.
The User Defined menu item is disabled if no user-defined charts or chart windows have been created or loaded during this Oracle Performance Manager session.
The Charts menu items allow you to define and modify charts and chart windows.
The Charts menu includes the following menu items:
Displays the New SQL Chart property sheet, from which you can enter SQL statements to gather realtime database statistics, and then specify how these statistics will be displayed in a chart. For more information, see "Defining or Modifying Charts".
Displays the Modify SQL Chart property sheet, from which you can modify the SQL statement and display options for an existing chart. Using this property sheet, you can also delete a user-defined chart, or display the SQL statement and display options for a predefined chart. For more information, see "Defining or Modifying Charts".
Displays the New Window property sheet, from which you can define a new chart window to display one or more user-defined or multiple predefined charts. For more information, see "Displaying Charts in Chart Windows".
Displays the Modify Window property sheet, from which you can add or delete existing charts from an existing user-defined chart window. You can also delete user-defined chart windows using this property sheet. For more information, see "Displaying Charts in Chart Windows".
The Record menu items allow you to record data you can then display in Oracle Performance Manager charts. For more information, see "Working with Historical Data".
The Record menu includes the following menu items:
Allows you to begin recording data. This menu item is disabled when a data recording session is currently in progress.
| Attention:
Do not modify a chart or window using the Modify Chart or Modify Window property sheets while you are recording data for that chart or window. |
Allows you to stop recording data. This menu item is enabled when a data recording session is currently in progress.
Allows you to play back on a displayed chart data you have previously collected.
Allows you to delete a named historical data collection. For more information, see "Deleting an Historical Data Collection".
The Help menu items allow you to obtain information on using Oracle Performance Manager.
The Help menu includes the following menu items:
Displays an overview of the Oracle Performance Monitoring applications.
Search for Help On
Displays an alphabetical list of Help topics.
Displays information about using the Help system.
Displays version information for this release of Oracle Performance Manager.
Clicking the right mouse button on a displayed chart allows you to drill down from or customize the chart. For more information, see "Customizing the Chart Display".
Clicking the right mouse button on a chart legend displays a menu that allows you to customize the chart legend. For more information, see "Customizing the Chart Legend".
You can change the presentation format of any chart to any chart type that Oracle Performance Manager provides. The easiest way is to click on a displayed chart using the right mouse button, select Type, and then select one of the chart type options. You can also change the chart type using the Chart Properties property sheet. For more information, see "Customizing Display Elements of Charts".
Oracle Performance Manager provides the following chart types.
Area charts show the relative importance of values over a period of time.
You can use 3D effects, zoom in, and rotation features with Area charts.
Line charts show trends or changes in data over a period of time. This is the default format for predefined charts displaying rates per unit of time.
You can use 3D effects, zoom in, and rotation features with Line charts.
When you first display a Line chart, you will notice the addition over time of tics at the bottom of the chart. Each of these tics represents a polling event. A timestamp marks the tenth polling event, so that the time interval between each timestamp spans 10 polling events.
Bar charts show discrete measurements over a period of time.
You can use 3D effects, zoom in, and rotation features with Horizontal Bar charts.
Pie charts show the relationship or proportions of parts to a whole. This is the default format for predefined charts displaying ratios.
Oracle Performance Manager allows you to display several variations of Pie charts, including: standard Pie; 2D exploding Pie (in which you can drag one or more slices out from the pie for emphasis); and 3D versions of these Pie charts.
You can use the rotation feature with Pie charts.
Vertical bar charts show discrete changes over time.
You can use 3D effects, zoom in, and rotation features with Columns charts.
Cube charts show the relative importance of values over a period of time. Cubes replace bars as data markers. You can display the cube data markers as 3D cubes, conics, or cylinders.
You can use the zoom in, special 3D effects, and rotation features with Cube charts.
Table charts present text information, or a large number of instances, in a format that is easy to review. This is the default format for predefined charts displaying such information. The Table chart type is also the default format for a new chart you define yourself.
| Attention:
If you cannot see the entire contents of a field in a Table chart, you can double-click on the field, and use the arrow keys to scroll in the field. |
