About This Guide

This guide explains how to use the Silicon Graphics Performance Co-Pilot (PCP) tools to monitor ORACLE database performance. The software described here is packaged as the Performance Co-Pilot for ORACLE product. You need both PCP (version 2.0 or later) and ORACLE (version 7 or 8) installed on your system(s) to take advantage of this software. If you have already installed this product, you may refer to the abbreviated installation instructions in Appendix A.

This section includes brief descriptions of the contents of this guide and an explanation of typographical conventions used.

What This Guide Contains

This guide contains the following chapters:

Conventions Used in This Guide

These type conventions and symbols are used in this guide:


Function and subroutine names, language keywords and data types, literal command-line arguments (options), nonalphabetic data types, and operators.


BNF entries, executable names, filenames, glossary entries (online, these show up underlined), IRIX commands, manual/book titles, new terms, onscreen button names, program variables, tools, utilities, variable command-line arguments, variable coordinates, and variables to be supplied by the user in examples, code, and syntax statements.


Error messages, prompts, and onscreen text.

Bold Fixed-width 

User input, including keyboard keys (printing and nonprinting); literals supplied by the user in examples, code, and syntax statements.


Environment variables, operator names, directives, defined constants, macros in C programs.

Helvetica Bold  

Hardware labels.


(Double quotation marks) Onscreen menu items and references in text to document section titles.


(Parentheses) Following function names, surround function arguments or are empty if the function has no arguments. Following commands, surround the reference page (manual page) section number.


(Brackets) Surrounding optional syntax statement arguments.


Shell prompt for the superuser (root).


C shell prompt for users other than root.

This guide uses the standard UNIX convention for referring to reference pages. The entry name is followed by the section number in parentheses. For example, pmchart(1) designates the online manual page for the pmchart command. If this reference page is installed, you can click on this entry to display the information.

Additional Resources

The following sections describe resources for obtaining further information.

PCP Documentation

The Performance Co-Pilot User's and Administrator's Guide describes your PCP software in detail. This is your main resource for using the base PCP software.

The Performance Co-Pilot Programmer's Guide provides information on the application programming interface (API) for extending PCP services, and the steps necessary to add new collection agents into the PCP framework.

Reference Pages

Table i shows some important reference pages for PCP commands and libraries.

Table 1. Selected PCP Commands and Libraries

Reference Page

Summary Information


Administration of Performance Co-Pilot archive log files


Visualize disk I/O rates and performance


Visualize CPU utilization/performance


Visualize performance of NFS statistics


Plot ORACLE database performance metrics against time


Introduction to the Performance Metrics API


Performance metrics collector daemon


Plot performance metrics against time


A simple performance metrics client


Introduction to the Performance Metrics Domain Agent support library


Cisco router performance metrics domain agent (PMDA)


Summary performance metrics domain agent (PMDA)


A miniature graphical performance metrics viewer


A miniature IRIX performance metrics viewer


A miniature ORACLE database performance metrics viewer


Inference engine for performance metrics


Display information about performance metrics


High-level system performance overview


The performance metrics namespace

Release Notes

Release notes provide specific information about the current release. Each optional product has its own set of release notes. Release Notes are available online through the relnotes command, or graphically through the grelnotes command.

Web Resources

If you have access to the World Wide Web you can find up-to-date information about Performance Co-Pilot at this location:

  • http://www.sgi.com/software/co-pilot/

At a related Web site, you can find additional Silicon Graphics information, including the Technical Publications Library:

  • http://techpubs.sgi.com