Contents

• Notices

• Preface

• Part 1: Overview

  • 1. Overview of PFM - RM for Oracle

    • 1.1 Features of PFM - RM for Oracle

      • 1.1.1 Monitor the multiple target hosts agentlessly

      • 1.1.2 Collecting Oracle performance data

      • 1.1.3 Collecting performance data based on its characteristics

      • 1.1.4 Saving performance data

      • 1.1.5 Notifying users of problems in Oracle operation

      • 1.1.6 Easy definition of alarms and reports

      • 1.1.7 Operation with a cluster system

    • 1.2 Overview of collection and management of performance data

    • 1.3 Example of performance monitoring using PFM - RM for Oracle

      • 1.3.1 Purpose of performance monitoring

      • 1.3.2 Determining a baseline

      • 1.3.3 Search processing performance

      • 1.3.4 Data update processing performance

      • 1.3.5 Oracle instance operation monitoring

      • 1.3.6 Disk monitoring

      • 1.3.7 Monitoring wait events concerning REDO log file

• Part 2: Configuration and Operations

  • 2. Installation and Setup

    • 2.1 Installation and setup (Windows)

      • 2.1.1 Preparation for installing and setting up PFM - RM for Oracle (Windows)

      • 2.1.2 Installation and setup workflow (Windows)

      • 2.1.3 Installation procedure (Windows)

      • 2.1.4 Setting up PFM - RM for Oracle (Windows)

    • 2.2 Installation and setup (UNIX)

      • 2.2.1 Preparation for installing and setting up PFM - RM for Oracle (UNIX)

      • 2.2.2 Installation and setup workflow (UNIX)

      • 2.2.3 Installation procedure (UNIX)

      • 2.2.4 Setting up PFM - RM for Oracle (UNIX)

    • 2.3 Setup cancellation and uninstallation (Windows)

      • 2.3.1 Cautionary notes on setup cancellation and uninstallation (Windows)

      • 2.3.2 Procedure for canceling setup (Windows)

      • 2.3.3 Procedure for uninstallation (Windows)

    • 2.4 Setup cancellation and uninstallation (UNIX)

      • 2.4.1 Cautionary notes on setup cancellation and uninstallation (UNIX)

      • 2.4.2 Procedure for canceling setup(UNIX)

      • 2.4.3 Procedure for uninstallation (UNIX)

    • 2.5 Changing the system configuration of PFM - RM for Oracle

    • 2.6 Changing the operation of PFM - RM for Oracle

      • 2.6.1 Changing the storage location of performance data

      • 2.6.2 Updating a monitoring target

      • 2.6.3 Updating an instance environment

      • 2.6.4 Checking how monitoring targets are configured

      • 2.6.5 Cancellation facility for Oracle access during record collection

    • 2.7 Backup and restoration

      • 2.7.1 Backup

      • 2.7.2 Restoration

    • 2.8 Online manuals

      • 2.8.1 Setting procedure

      • 2.8.2 Viewing the manual

  • 3. Operating PFM - RM for Oracle in a Cluster System

    • 3.1 Cluster system overview

      • 3.1.1 HA cluster system

      • 3.1.2 Load-balancing cluster system

    • 3.2 Processing during failover

      • 3.2.1 Failover when a failure occurs on a monitoring host

      • 3.2.2 Failure occurs on PFM - RM for Oracle host

      • 3.2.3 Effects when PFM - Manager stops

    • 3.3 Installation and setup (Windows)

      • 3.3.1 Preparation for installation and setup (Windows)

      • 3.3.2 Installation and setup workflow (Windows)

      • 3.3.3 Installation procedure (Windows)

      • 3.3.4 Setup procedure (Windows)

    • 3.4 Installation and setup (UNIX)

      • 3.4.1 Preparation for installation and setup (UNIX)

      • 3.4.2 Installation and setup workflow (UNIX)

      • 3.4.3 Installation procedure (UNIX)

      • 3.4.4 Setup procedure (UNIX)

    • 3.5 Setup cancellation and uninstallation (Windows)

      • 3.5.1 Setup cancellation and uninstallation workflow of PFM - RM for Oracle (Windows)

      • 3.5.2 Setup cancellation procedure (Windows)

      • 3.5.3 Uninstallation procedure (Windows)

    • 3.6 Setup cancellation and uninstallation (UNIX)

      • 3.6.1 Setup cancellation and uninstallation workflow of PFM - RM for Oracle (UNIX)

      • 3.6.2 Setup cancellation procedure (UNIX)

      • 3.6.3 Uninstallation procedure (UNIX)

    • 3.7 Changing the operation of PFM - RM for Oracle

      • 3.7.1 Updating a monitoring target

      • 3.7.2 Updating an instance environment

    • 3.8 Notes on operating PFM - RM for Oracle in a cluster system

      • 3.8.1 Host name in the collected performance data

      • 3.8.2 Exporting and importing the logical-host environment definition file

• Part 3: Reference

  • 4. Monitoring template

    • Overview of the monitoring template

    • Format of alarm explanations

    • List of alarms

    • Buffer Cache Usage

    • Buffer Cache Waits

    • Dict. Cache Usage

    • Disk Sorts

    • Free List Waits

    • Full Table Scans

    • Library Cache Usage

    • Redo Log Contention

    • Server Status

    • Tablespace Usage

    • Format of report explanations

    • Organization of report folders

    • List of reports

    • Blocking Locks(5.0)

    • Cache Usage

    • Cache Usage Status(Multi-Agent)

    • Cache Usage Trend(Multi-Agent)

    • Database Activity Status(5.0)

    • Database Activity Status Detail(5.0)

    • Database Activity Status(Multi-Agent)

    • Database Activity Trend(Multi-Agent)

    • Database Space Overview(5.0)

    • Database Space Summary(Multi-Agent)(5.0)

    • Database Space Trend(Multi-Agent)(5.0)

    • Datafile I/O Activity Detail(5.0)

    • Datafile I/O Status Detail(Reads)(5.0)

    • Datafile I/O Status Detail(Writes)(5.0)

    • Datafile I/O Status Summary(5.0)

    • Datafile I/O Trend Detail(Reads)(5.0)

    • Datafile I/O Trend Detail(Writes)(5.0)

    • Datafile I/O Trend Summary(5.0)

    • Disk Sorts - Top 10 Sessions(5.0)

    • Full Table Scans

    • I/O Activity - Top 10 Datafiles(5.0)

    • Lock Usage - Top 10 Sessions(5.0)

    • Locked Objects(5.0)

    • Longest Transactions - Top 10 Sessions(5.0)

    • Memory Usage - Top 10 Sessions(5.0)

    • Open Cursors

    • Physical I/O - Top 10 Sessions(5.0)

    • Redo Log Buffer Contention

    • Server Configuration Status

    • Session Detail(5.0)

    • Session Statistics Detail

    • SGA Status(5.0)

    • SGA Status Summary(5.0)

    • SQL Text

    • System Overview(5.0)(real-time report on the overall status of instance)

    • System Overview(5.0) (real-time report on the general status of instance)

    • Tablespace Status

    • Tablespace Status Detail

  • 5. Records

    • Data model

    • Format of record explanations

    • List of ODBC key fields

    • Summary rules

    • List of data types

    • Field values

    • Fields added only when data is stored in the Store database

    • Fields output when data stored in the Store database is exported

    • Notes on records

    • List of records for PFM - RM for Oracle

    • Activity Summary (PD_PDAS)

    • ASM Disk (PD_PDDK)

    • ASM Disk Group Interval (PI_PIDG)

    • Collection Instance 2 (PD_PCI)

    • Collection Tablespace 2(PD_PCTS)

    • Data File (PD_PDDF)

    • Data File Interval (PI_PIDF)

    • Database (PD_PDDB)

    • Database Interval (PI_PIDB)

    • Instance (PD_PDI)

    • Instance Availability (PD_PDIA)

    • Lock Waiters (PD_PDLW)

    • Minimum Database Interval 2 (PI_PMDB)

    • Minimum Data File Interval 2 (PI_PMDF)

    • Minimum Tablespace Interval 2 (PI_PMTS)

    • Open Cursor (PD_PDOC)

    • Parameter Values (PD_PDP)

    • Session Detail (PD_PDS)

    • Session I/O Interval (PI_PIIO)

    • Session Statistics Summary (PD_PDS2)

    • SGA Components (PD_PDSG)

    • SQL Text (PD_PDSQ)

    • System Stat Summary (PD)

    • System Stat Summary Interval (PI)

    • Tablespace (PD_PDTS)

    • Tablespace Fragmentation (PD_PDTF)

    • Tablespace Interval (PI_PITS)

    • Transaction (PD_PDTR)

    • Transaction Lock (PD_PDTL)

  • 6. Messages

    • 6.1 Message format

      • 6.1.1 Format of output messages

      • 6.1.2 Format of message explanations

    • 6.2 Message output destinations

    • 6.3 List of messages output to the Windows event log and syslog

    • 6.4 Messages

      • KAVL18001-I

      • KAVL18002-E

      • KAVL18003-I

      • KAVL18004-E

      • KAVL18009-W

      • KAVL18010-E

      • KAVL18011-E

      • KAVL18014-E

      • KAVL18015-E

      • KAVL18017-E

      • KAVL18018-E

      • KAVL18019-W

      • KAVL18020-E

      • KAVL18021-E

      • KAVL18022-E

      • KAVL18023-E

      • KAVL18301-W

      • KAVL18302-W

      • KAVL18303-E

      • KAVL18304-E

      • KAVL18305-E

      • KAVL18306-W

      • KAVL18401-W

      • KAVL18402-E

      • KAVL18501-E

      • KAVL18502-E

      • KAVL18504-E

      • KAVL18505-I

      • KAVL18506-E

      • KAVL18507-E

      • KAVL18508-E

      • KAVL18509-E

      • KAVL18510-E

      • KAVL18511-E

      • KAVL18512-E

      • KAVL18513-E

      • KAVL18514-E

      • KAVL18515-E

      • KAVL18516-E

      • KAVL18517-E

      • KAVL18518-E

      • KAVL18519-E

      • KAVL18600-E

      • KAVL18601-I

      • KAVL18602-I

      • KAVL18603-I

      • KAVL18604-I

      • KAVL18605-I

      • KAVL18606-I

      • KAVL18607-I

      • KAVL18608-I

      • KAVL18609-I

      • KAVL18610-I

      • KAVL18611-I

      • KAVL18612-I

      • KAVL18613-W

      • KAVL18614-E

      • KAVL18615-W

      • KAVL18616-E

      • KAVL18617-E

      • KAVL18618-E

      • KAVL18619-W

      • KAVL18620-W

      • KAVL18621-E

      • KAVL18622-E

      • KAVL18623-W

      • KAVL18624-W

      • KAVL18625-E

      • KAVL18629-I

      • KAVL18630-W

      • KAVL18631-E

      • KAVL18632-W

      • KAVL18633-W

      • KAVL18634-W

      • KAVL18635-I

      • KAVL18636-I

      • KAVL18638-W

      • KAVL18639-E

• Part 4: Troubleshooting

  • 7. Error Handling Procedures

    • 7.1 When an error occurs

    • 7.2 Troubleshooting procedures

      • 7.2.1 Problems relating to the start and setup of services

      • 7.2.2 Problems relating to the collection and management of performance data

      • 7.2.3 Other problems

    • 7.3 Log information

      • 7.3.1 Types of log information

      • 7.3.2 List of log files and directories

    • 7.4 Required troubleshooting information

      • 7.4.1 In Windows

      • 7.4.2 In UNIX

    • 7.5 Collecting troubleshooting information

      • 7.5.1 In Windows

      • 7.5.2 In UNIX

    • 7.6 Detecting errors in Performance Management

    • 7.7 Recovering from errors in Performance Management

• Appendixes

  • A. Estimating System Requirements

    • A.1 Memory requirements

    • A.2 Disk space requirements

    • A.3 Disk space requirements for operation in a cluster system

  • B. Kernel Parameters

    • B.1 Linux

  • C. List of Identifiers

  • D. List of Processes

  • E. List of Port Numbers

    • E.1 Port numbers for PFM - RM for Oracle

    • E.2 Routing through a firewall

  • F. PFM - RM for Oracle Properties

    • F.1 List of Remote Monitor Store service properties

    • F.2 List of Remote Monitor Collector service properties

    • F.3 List of remote agent and group agent properties

  • G. List of Files and Directories

    • G.1 PFM - RM for Oracle files and directories

    • G.2 List of files and directories in the message catalog storage directory

  • H. Migration Procedure and Notes on Migration

  • I. Precautions Regarding Permissions

    • I.1 When the sp_rist.sql script is executed

    • I.2 When the sp_rdrp.sql script is executed

    • I.3 When the mk_rmus.sql script is executed

    • I.4 When performance information is collected

  • J. Version Compatibility

  • K. Outputting Action Log Information

    • K.1 Event types output to the action log

    • K.2 Format for saving the action log files

    • K.3 Action log output format

    • K.4 Settings for outputting action logs

  • L. Linking with JP1/SLM

  • M. About Communication in IPv4 Environments and IPv6 Environments

  • N. Version Revisions

    • N.1 Revisions in 11-00

    • N.2 Revisions in 10-50

    • N.3 Revisions in 10-00

  • O. Reference Material for This Manual

    • O.1 Related publications

    • O.2 Conventions: Abbreviations for product names

    • O.3 Conventions: Acronyms

    • O.4 Conventions: Product names, service IDs, and service keys

    • O.5 Conventions: Directory names

    • O.6 Conventions: Installation folder

    • O.7 Conventions: KB, MB, GB, and TB

  • P. Glossary

• Index

To Page Top