HITACHI Inspire The Next

Job Management Partner 1 Version 10

Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

3021-3-351(E)


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
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
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)
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
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 command execution
7.2.3 Problems relating to report definitions
7.2.4 Problems relating to alarm definitions
7.2.5 Problems relating to the collection and management of performance data
7.2.6 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 (x86), Linux (x64)
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
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/ITSLM
M. About Communication in IPv4 Environments and IPv6 Environments
N. Version Revisions
N.1 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 Supported NNM products
O.8 Conventions: KB, MB, GB, and TB
P. Glossary
Index