Oracle7 Server Manager User's Guide

Library

Product

Contents

Index

Overview of the System Monitors

This chapter describes the basic elements and operation of the System Monitors, which are part of Server Manager. It explains how to:

Start a System Monitor

View the monitor's statistics

Sample statistics

Filter statistics

The System Monitors

The System Monitors allow you to collect and inspect performance statistics. You can collect these statistics as frequently as you like by setting specific collection intervals.

Table 10 - 1 describes the monitors available in Server Manager. For a detailed description of each monitor, see Chapter 11, "Monitoring System Performance."

Using the System Monitors

Because the System Monitors utilize information in the dynamic performance tables, you must have access to these tables to use the monitors. To grant all users access to the dynamic performance tables used by the System Monitors, the database administrator can run the script UTLMONTR.SQL. This script grants access to these tables to PUBLIC.

Additional Information: The location of the UTLMONTR.SQL script is platform dependent. For information about running UTLMONTR.SQL, see your operating system-specific documentation.

You can also grant specific users access to the individual views used by each monitor. For a list of the views used by each monitor, see Chapter 11, "Monitoring System Performance."

For monitors that include statistics related to time, you may want to set the initialization parameter TIMED_STATISTICS to TRUE. When TIMED_STATISTICS is TRUE, Oracle gathers timed-based statistics. If TIMED_STATISTICS is FALSE, statistics related to time are set to zero. For example, the statistics for read time and write time in the File I/O Monitor are not collected if TIMED_STATISTICS is FALSE.

For more information about the TIMED_STATISTICS parameter and setting initialization parameters, see the Oracle7 Server Administrator's Guide.

Monitor Name Monitor Function
Circuit Monitor Displays information about the shared servers' virtual circuits, through which users connect to the database.
Dispatcher Monitor Displays information about the shared server's dispatcher processes.
File I/O Monitor Displays the read and write activity for each file in the database.
Latch Monitor Displays the latches on shared internal data structures in the SGA.
Library Cache Monitor Displays the activity in and the effectiveness of the library cache.
Lock Monitor Displays current database locks.
Process Monitor Displays all background and user processes currently accessing the database through the current instance.
Queue Monitor Displays information on the multi-threaded server's message queues.
Rollback Monitor Displays the current status of rollback segments.
Session Monitor Displays statistics and information for each user session in the current instance.
Shared Server Monitor Displays statistics for the shared server processes.
SQL Area Monitor Displays the memory used to process SQL statements that have been or are being executed.
System I/O Monitor Displays the percentage of I/O activity generated by each background and user process that is accessing the database through the current instance.
System Statistics Monitor Displays runtime statistics for the system.
Table Access Monitor Displays objects being accessed and the session Id that is accessing them.
Tablespace Monitor Displays information about the tablespaces created in the database.

Table 10 - 1. System Monitors

Starting a Monitor

You can start a monitor from any Server Manager window by choosing Monitor from the File menu. You can also start a monitor by executing the MONITOR command in a SQL Worksheet. For information on starting a monitor from a worksheet, see Chapter 9, "Using the SQL Worksheet."

When you start a monitor, the monitor is connected to the same database as the window from which you started the monitor and shows statistics for that database instance.

When you choose Monitor from the File menu or execute the MONITOR command from a SQL Worksheet, the Monitor dialog box appears. The following figure illustrates the Monitor dialog box.

Figure 10 - 1. Monitor Dialog Box

In the Monitor dialog box, you select the type of monitor to start, and then click OK to start the monitor. You can also start a monitor by double-clicking its type in the scrolling list.

If the monitor you selected has already been started, Server Manager brings that window to the front. You may run only one monitor of each type for each instance to which you are connected.

Common Interface Elements

Although each monitor type has its own window, most of the elements and functions of the monitor windows are the same. This section describes these common features. For a detailed description of each monitor window, see Chapter 11, "Monitoring System Performance."

The following figure illustrates a monitor window. Only the left-most columns are displayed. To view additional columns, you need to scroll the column list to the right.

Figure 10 - 2. A Monitor Window

Statistics Lists

When you open a monitor window, a statistics list appears. The statistics list contains the statistics displayed in the monitor.

By default, the statistics are sorted on the first column. You can sort a statistics list on another column by clicking that column heading. A column name appears in bold to indicate that the statistics list is sorted on that column.

A few monitors contain columns on which you cannot sort the statistics list. When you click the column heading for one of these columns, the statistics list is not sorted again.

Note: When you click a column heading to sort on that column, a new sample is automatically taken.

Sampling Controls

The statistics in a monitor can be sampled cyclically (the default) or on demand. To sample cyclically, click Cycle. Use the Interval pop-up menu to set the sampling interval. The default sampling interval is 30 seconds.

The following figure illustrates setting the sampling interval.

Figure 10 - 3. Setting the Sampling Interval

The Interval pop-up menu contains several predefined sampling intervals that you can select from. You can also specify a different interval by choosing Other from the Interval pop-up menu.

When you choose Other, the Other Interval dialog box appears. The following figure illustrates the Other Interval dialog box.

Figure 10 - 4. Other Interval Dialog Box

In the Other Interval dialog box, you can specify a sampling interval in minutes and seconds. The minimum sampling interval is 15 seconds. The maximum is 100 minutes and 39 seconds, which you can express as 99 minutes and 99 seconds in the Other Interval dialog box.

When sampling cyclically, clicking the Hold button allows you to suspend sampling. The Hold button is replaced with a Resume button and the current statistics are not refreshed. To resume sampling, click Resume.

To sample statistics on demand, click Sample on Demand. The Hold button is replaced by a Sample button. Click Sample each time you want to sample statistics. The following figure illustrates sampling on demand.

Figure 10 - 5. Sampling on Demand

Filtering Statistics

Some monitors provide filtering, which allows you to specify the objects for which to display statistics. To use filtering, enter text string(s) in the filter text entry field(s) and click Filter. Clicking Filter establishes the filtering and takes a new sample. Figure 10 - 6 shows an example of using filters in a monitor.

For non-numeric filters, you may use the SQL wildcard characters underscore (_) and percent sign (%). An underscore represents a single character; a percent sign represents any number of characters. A percent sign is implicitly added to the end of a filter text string.

Figure 10 - 6. Using Filters in a Monitor

In the filtering example in Figure 10 - 6, note that the percent sign wildcard character is used in the Statement filter. Statistics are displayed only for statements that contain the text string "privilege".

When there is more than one filter field, the filters are AND-ed together. That is, only statistics that match all the filters are displayed.

By default, the filter text entry fields are empty. If a filter text entry field is empty, then all values match that filter.

Prev Next

Library

Product

Contents

Index

*Monitor Name*	*Monitor Function*
Circuit Monitor	Displays information about the shared servers' virtual circuits, through which users connect to the database.
Dispatcher Monitor	Displays information about the shared server's dispatcher processes.
File I/O Monitor	Displays the read and write activity for each file in the database.
Latch Monitor	Displays the latches on shared internal data structures in the SGA.
Library Cache Monitor	Displays the activity in and the effectiveness of the library cache.
Lock Monitor	Displays current database locks.
Process Monitor	Displays all background and user processes currently accessing the database through the current instance.
Queue Monitor	Displays information on the multi-threaded server's message queues.
Rollback Monitor	Displays the current status of rollback segments.
Session Monitor	Displays statistics and information for each user session in the current instance.
Shared Server Monitor	Displays statistics for the shared server processes.
SQL Area Monitor	Displays the memory used to process SQL statements that have been or are being executed.
System I/O Monitor	Displays the percentage of I/O activity generated by each background and user process that is accessing the database through the current instance.
System Statistics Monitor	Displays runtime statistics for the system.
Table Access Monitor	Displays objects being accessed and the session Id that is accessing them.
Tablespace Monitor	Displays information about the tablespaces created in the database.