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
- Part 2: Configuration and Operations
- 2. Installation and Setup
- 2.1 Installation and setup (Windows)
- 2.2 Installation and setup (UNIX)
- 2.3 Setup cancellation and uninstallation (Windows)
- 2.4 Setup cancellation and uninstallation (UNIX)
- 2.5 Changing the system configuration of PFM - RM for Oracle
- 2.6 Changing the operation of PFM - RM for Oracle
- 2.7 Backup and restoration
- 2.8 Online manuals
- 3. Operating PFM - RM for Oracle in a Cluster System
- 3.1 Cluster system overview
- 3.2 Processing during failover
- 3.3 Installation and setup (Windows)
- 3.4 Installation and setup (UNIX)
- 3.5 Setup cancellation and uninstallation (Windows)
- 3.6 Setup cancellation and uninstallation (UNIX)
- 3.7 Changing the operation of PFM - RM for Oracle
- 3.8 Notes on operating PFM - RM for Oracle in a cluster system
- 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.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.3 Log information
- 7.4 Required troubleshooting information
- 7.5 Collecting troubleshooting information
- 7.6 Detecting errors in Performance Management
- 7.7 Recovering from errors in Performance Management
- Appendixes
- A. Estimating System Requirements
- B. Kernel Parameters
- C. List of Identifiers
- D. List of Processes
- E. List of Port Numbers
- F. PFM - RM for Oracle Properties
- G. List of Files and Directories
- H. Migration Procedure and Notes on Migration
- I. Precautions Regarding Permissions
- J. Version Compatibility
- K. Outputting Action Log Information
- L. Linking with JP1/ITSLM
- M. About Communication in IPv4 Environments and IPv6 Environments
- N. Version Revisions
- O. Reference Material for This Manual
- P. Glossary
- Index
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.