![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Function
The Activity Summary (PD_PDAS) record stores performance data indicating the operating status (at a specific point in time) of the Oracle system.
Default and changeable values
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 300 | Y |
| Collection Offset | 30 | Y |
| Log | No | Y |
| LOGIF | (Blank) | Y |
ODBC key fields
None
Lifetime
From the creation to the deletion of an Oracle instance
Record size
Fields
| PFM - View name (PFM - Manager name) |
Description | Summary | Format | Delta | Supported version | Data source |
|---|---|---|---|---|---|---|
| Active Transactions (ACTIVE_TRANSACTIONS) |
Number of active transactions in active sessions | -- | long | No | All | SUM(V$ROLLSTAT.XACTS) |
| Avg Wait (AVERAGE_WAIT) |
Average wait time for all events in all sessions | -- | ulong | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
| Avg Wait String (AVERAGE_WAIT_STRING) |
Average wait time for all events in all sessions (character string) | -- | string(20) | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
| Cursor Open Hit % (CURSOR_OPEN_HIT_PERCENTAGE) |
Percentage ratio of open cursors that were found during cursor search | -- | double | No | All | V$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100 |
| Cursor Open Hits (CURSOR_OPEN_HITS) |
Total cursor open hits | -- | ulong | No | All | V$SYSTEM_CURSOR_CACHE.HITS |
| Cursor Opens (CURSOR_OPENS) |
Total cursor opens | -- | ulong | No | All | V$SYSTEM_CURSOR_CACHE.OPENS |
| DML Locks % (PERCENT_DML_LOCKS) |
Percentage ratio of DML locks to the DML_LOCKS parameter value in the init.ora file | -- | double | No | All | (COUNT(DBA_DML_LOCKS) / init.ora DML_LOCKS) * 100 |
| DML Locks Held (DML_LOCKS_HELD) |
Number of current DML locks | -- | long | No | All | COUNT(DBA_DML_LOCKS) |
| Enqueue Resources % (PERCENT_ENQUEUE_RESOURCES) |
Percentage ratio of locks to the value of the ENQUEUE_RESOURCES parameter in the init.ora file Always 0 if the monitoring target is Oracle 10g Release2 or later. |
-- | double | No | All | (COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL / init.ora ENQUEUE_RESOURCES) * 100 |
| Locks Held (LOCKS_HELD) |
Number of current locks | -- | long | No | All | COUNT(V$LOCK) where V$LOCK.LMODE is NOT NULL |
| Open Cursors (OPEN_CURSORS) |
Number of current open cursors | -- | long | No | All | COUNT(V$OPEN_CURSOR) |
| Open Cursors % (PERCENT_OPEN_CURSORS) |
Percentage ratio of open cursors to the value of the OPEN_CURSORS parameter in the init.ora file | -- | double | No | All | (COUNT(V$OPEN_CURSOR) / init.ora OPEN_CURSORS) * 100 |
| Processes (PROCESSES) |
Number of current Oracle processes | -- | ulong | No | All | COUNT(V$PROCESS) |
| Processes % (PERCENT_PROCESSES) |
Percentage ratio of processes to the value of the PROCESSES parameter in the init.ora file | -- | double | No | All | (COUNT(V$PROCESS) / init.ora PROCESSES) * 100 |
| Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record name (always PDAS) | -- | string(4) | No | All | Remote Monitor Collector |
| Session Events (SESSION_EVENTS) |
Number of events queued by sessions | -- | ulong | No | All | COUNT(V$SESSION_EVENT) |
| Session Waits (SESSION_WAITS) |
Number of session waits | -- | ulong | No | All | COUNT(V$SESSION_WAIT) |
| Sessions (SESSIONS) |
Number of current sessions | -- | ulong | No | All | COUNT(V$SESSION) |
| Sessions % (PERCENT_SESSIONS) |
Percentage ratio of sessions to the value of the SESSIONS parameter in the init.ora file | -- | double | No | All | (COUNT(V$SESSION) / init.ora SESSIONS) * 100 |
| Start Time (START_TIME) |
Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| System Sessions (SESSIONS_SYSTEM) |
Number of current system sessions | -- | ulong | No | All | COUNT(V$SESSION) where V$SESSION.TYPE<>'USER' |
| Table Accesses (TABLE_ACCESSES) |
Number of current table accesses | -- | long | No | All | COUNT(V$ACCESS) |
| Time Waited (TIME_WAITED) |
Total length of time that all sessions queued all events | -- | double | No | All | SUM(V$SESSION_EVENT.TIME_WAITED) |
| Time Waited String (TIME_WAITED_STRING) |
Total length of time that all sessions queued all events (character string) | -- | string(20) | No | All | SUM(V$SESSION_EVENT.TIME_WAITED) |
| Total Timeouts (TOTAL_TIMEOUTS) |
Total number of timeouts for all events in all sessions | -- | ulong | No | All | SUM(V$SESSION_EVENT.TOTAL_TIMEOUTS) |
| Total Waits (TOTAL_WAITS) |
Number of waits for all events in all sessions | -- | ulong | No | All | SUM(V$SESSION_EVENT.TOTAL_WAITS) |
| Transactions % (PERCENT_TRANSACTIONS) |
Percentage ratio of the number of transactions to the value of the TRANSACTIONS parameter in the init.ora file | -- | double | No | All | (SUM(V$ROLLSTAT.XACTS) / init.ora TRANSACTION) * 100 |
| User Sessions (SESSIONS_USER) |
Number of current user sessions | -- | ulong | No | All | COUNT(V$SESSION) where V$SESSION.TYPE = 'USER' |
| VA DeviceID (VADEVICEID) |
Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.