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.
This guide contains the following chapters:
Chapter 1, “Monitoring ORACLE Performance With PCP,” provides an overview of how to monitor ORACLE databases with PCP.
Chapter 2, “Installation Instructions,” gives instructions for installing the necessary subsystems to support local databases and remote databases, tells how to upgrade existing installations, and shows how to remove PCP for ORACLE.
Chapter 3, “Managing Multiple ORACLE Databases,” describes strategies for monitoring multiple ORACLE databases on remote servers or local servers.
Chapter 4, “ORACLE Response-Time Agent,” provides information on using the pmdaoraping agent for measuring response time from ORACLE databases.
Chapter 5, “ORACLE Performance Visualization Tools,” provides information on several commands for visualizing ORACLE database performance.
Appendix A, “Abbreviated Installation Instructions,” gives instructions for getting PCP for ORACLE set up rapidly.
Appendix B, “Troubleshooting PCP for ORACLE,” provides troubleshooting help for this product.
These type conventions and symbols are used in this guide:
| Bold | Function and subroutine names, language keywords and data types, literal command-line arguments (options), nonalphabetic data types, and operators. | |
| Italics | 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. | |
| Fixed-width | Error messages, prompts, and onscreen text. | |
| Bold Fixed-width |
| |
| ALL CAPS | 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.
The following sections describe resources for obtaining further information.
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.
Table i shows some important reference pages for PCP commands and libraries.
Table 1. Selected PCP Commands and Libraries
Reference Page | Summary Information |
|---|---|
cron.pmdaily(1) | Administration of Performance Co-Pilot archive log files |
dkvis(1) | Visualize disk I/O rates and performance |
mpvis(1) | Visualize CPU utilization/performance |
nfsvis(1) | Visualize performance of NFS statistics |
orachart(1) | Plot ORACLE database performance metrics against time |
PMAPI(3) | Introduction to the Performance Metrics API |
pmcd(1) | Performance metrics collector daemon |
pmchart(1) | Plot performance metrics against time |
pmclient(1) | A simple performance metrics client |
PMDA(3) | Introduction to the Performance Metrics Domain Agent support library |
pmdacisco(1) | Cisco router performance metrics domain agent (PMDA) |
pmdasummary(1) | Summary performance metrics domain agent (PMDA) |
pmgadgets(1) | A miniature graphical performance metrics viewer |
pmgirix(1) | A miniature IRIX performance metrics viewer |
pmgora(1) | A miniature ORACLE database performance metrics viewer |
pmie(1) | Inference engine for performance metrics |
pminfo(1) | Display information about performance metrics |
pmkstat(1) | High-level system performance overview |
pmns(4) | The performance metrics namespace |
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.
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