Oracle® Enterprise Manager
Metric Reference Manual
10g Release 1 (10.1)
Part No. B12015-01

June 2004


Oracle Enterprise Manager Metric Reference Manual, 10g Release 1 (10.1)
Part No. B12015-01
Copyright © 2004, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they
are provided under a license agreement containing restrictions on use and disclosure and are also protected
by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly,
or decompilation of the Programs, except to the extent required to obtain interoperability with other
independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in
the documentation, please report them to us in writing. This document is not warranted to be error-free.
Except as may be expressly permitted in your license agreement for these Programs, no part of these
Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any
purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on
behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical data"
pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As
such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation
and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license
agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial
Computer Software--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City,
CA 94065

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy and other measures to ensure the safe use of such applications if the Programs are used for such
purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third
parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites.
You bear all risks associated with the use of such content. If you choose to purchase any products or services
from a third party, the relationship is directly between you and the third party. Oracle is not responsible for:
(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the
third party, including delivery of products or services and warranty obligations related to purchased
products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from
dealing with any third party.


Contents
Send Us Your Comments .................................................................................................................. xxxix
Preface ................................................................................................................................................................ xli
Intended Audience..................................................................................................................................... xli
Purpose of This Manual ............................................................................................................................ xli
Documentation Accessibility .................................................................................................................... xli
Structure ..................................................................................................................................................... xlii
Related Documents ................................................................................................................................... xlv
Conventions .............................................................................................................................................. xlvi

1

How To Use This Manual
Structure of the Metric Reference Manual............................................................................................

Metric Information.............................................................................................................................
Examples of Metric Summary Tables..............................................................................................
Definitions of Columns in Metric Summary Tables .....................................................................
Abbreviations and Acronyms ..........................................................................................................
Background Information on Metrics, Thresholds, and Alerts ........................................................
Editing Thresholds.............................................................................................................................
Specifying Multiple Thresholds .......................................................................................................
Accessing Metrics Using the Grid Control Console......................................................................

Part I
2

1-1
1-1
1-2
1-2
1-3
1-4
1-4
1-4
1-5

Oracle Database Metrics

Database
Alert Log.....................................................................................................................................................
Alert Log Error Trace File .................................................................................................................
Alert Log Name ..................................................................................................................................
Archiver Hung Alert Log Error .......................................................................................................
Data Block Corruption Alert Log Error ..........................................................................................

Generic Alert Log Error.....................................................................................................................
Session Terminated Alert Log Error................................................................................................
Alert Log Error Status ..............................................................................................................................
Archiver Hung Alert Log Error Status............................................................................................
Data Block Corruption Alert Log Error Status ..............................................................................
Generic Alert Log Error Status.........................................................................................................

2-1
2-1
2-1
2-2
2-3
2-3
2-4
2-5
2-5
2-6
2-6
iii


Session Terminated Alert Log Error Status.................................................................................... 2-7
Archive Area.............................................................................................................................................. 2-7
Archive Area Used (%)...................................................................................................................... 2-8
Archive Area Used (KB).................................................................................................................... 2-9
Free Archive Area (KB) .................................................................................................................. 2-10
Total Archive Area (KB)................................................................................................................. 2-11
Data Guard ............................................................................................................................................. 2-11
Data Guard Status ........................................................................................................................... 2-12
Data Not Applied (logs) ................................................................................................................ 2-12

Data Not Applied (MB) ................................................................................................................. 2-13
Data Not Received (logs) ............................................................................................................... 2-14
Data Not Received (MB)................................................................................................................. 2-15
Database Files ........................................................................................................................................ 2-16
Average File Read Time (centi-seconds)...................................................................................... 2-16
Average File Write Time (centi-seconds)..................................................................................... 2-17
Database Job Status .............................................................................................................................. 2-18
Broken Job Count ............................................................................................................................ 2-18
Failed Job Count .............................................................................................................................. 2-18
Database Limits ..................................................................................................................................... 2-19
Current Logons Count.................................................................................................................... 2-19
Current Open Cursors Count........................................................................................................ 2-20
Lock Limit Usage (%) ..................................................................................................................... 2-20
Process Limit Usage (%)................................................................................................................. 2-21
Session Limit Usage (%) ................................................................................................................. 2-22
User Limit Usage (%)...................................................................................................................... 2-23
Database Services .................................................................................................................................. 2-24
Service CPU Time (per user call) (microseconds) ...................................................................... 2-24
Service Response Time (per user call) (microseconds).............................................................. 2-24
Deferred Transactions........................................................................................................................... 2-25
Deferred Transaction Count .......................................................................................................... 2-25
Deferred Transaction Error Count................................................................................................ 2-26
Dump Area ............................................................................................................................................. 2-27
Dump Area Directory..................................................................................................................... 2-27
Dump Area Used (%) ..................................................................................................................... 2-27
Dump Area Used (KB) ................................................................................................................... 2-28
Free Dump Area (KB) ..................................................................................................................... 2-29
Total Dump Area (KB).................................................................................................................... 2-30
Efficiency................................................................................................................................................. 2-30
Buffer Cache Hit (%) ....................................................................................................................... 2-30

CPU Usage (per second) ................................................................................................................ 2-32
CPU Usage (per transaction) ......................................................................................................... 2-32
Cursor Cache Hit (%)...................................................................................................................... 2-33
Data Dictionary Hit (%).................................................................................................................. 2-33
Database CPU Time (%) ................................................................................................................. 2-34
Library Cache Hit (%)..................................................................................................................... 2-35
Library Cache Miss (%) .................................................................................................................. 2-36
Parallel Execution Downgraded (per second) ............................................................................ 2-37

iv


Parallel Execution Downgraded (per transaction) .....................................................................
Parallel Execution Downgraded 25% or more (per second).....................................................
Parallel Execution Downgraded 25% or more (per transaction)..............................................
Parallel Execution Downgraded 50% or more (per second).....................................................
Parallel Execution Downgraded 50% or more (per transaction)..............................................
Parallel Execution Downgraded 75% or more (per second).....................................................
Parallel Execution Downgraded 75% or more (per transaction)..............................................
Parallel Execution Downgraded to Serial (per second).............................................................
Parallel Execution Downgraded to Serial (per transaction) .....................................................
PGA Cache Hit (%) .........................................................................................................................
Redo Log Allocation Hit (%) .........................................................................................................
Response Time (per transaction)...................................................................................................
Row Cache Miss Ratio (%) .............................................................................................................
Sorts in Memory (%) .......................................................................................................................
Global Cache Statistics.........................................................................................................................
Global Cache Average Convert Time (centi-seconds) ...............................................................
Global Cache Average CR Block Request Time (centi-seconds) ..............................................
Global Cache Average Current Block Request Time (centi-seconds)......................................

Global Cache Average Get Time (centi-seconds) .......................................................................
Global Cache Blocks Corrupt ........................................................................................................
Global Cache Blocks Lost ...............................................................................................................
Idle Events ..............................................................................................................................................
Invalid Objects.......................................................................................................................................
Total Invalid Object Count.............................................................................................................
Invalid Objects by Schema..................................................................................................................
Owner's Invalid Object Count.......................................................................................................
Recovery Area ........................................................................................................................................
Recovery Area Free Space (%).......................................................................................................
Response .................................................................................................................................................
State ...................................................................................................................................................
Status.................................................................................................................................................
User Logon Time (msec) ................................................................................................................
Session Suspended ...............................................................................................................................
Session Suspended by Data Object Limitation ...........................................................................
Session Suspended by Quota Limitation.....................................................................................
Session Suspended by Rollback Segment Limitation ................................................................
Session Suspended by Tablespace Limitation ............................................................................
SGA Pool Wastage.................................................................................................................................
Java Pool Free (%) ...........................................................................................................................
Large Pool Free (%) .........................................................................................................................
Shared Pool Free (%).......................................................................................................................
Snapshot Too Old ..................................................................................................................................
Snapshot Too Old due to Rollback Segment Limit ....................................................................
Snapshot Too Old due to Tablespace Limit ................................................................................
SQL Response Time..............................................................................................................................
SQL Response Time (%) .................................................................................................................
Suspended Session ...............................................................................................................................


2-38
2-38
2-39
2-39
2-40
2-41
2-41
2-42
2-42
2-43
2-43
2-44
2-45
2-45
2-47
2-47
2-47
2-48
2-49
2-49
2-50
2-51
2-53
2-53
2-53
2-54
2-54
2-54
2-55
2-55

2-55
2-56
2-56
2-56
2-57
2-57
2-57
2-57
2-57
2-58
2-58
2-59
2-59
2-60
2-60
2-60
2-61

v


Suspended Session Count..............................................................................................................
System Response Time Per Call .........................................................................................................
System Response Time (centi-seconds)........................................................................................
System Sessions Waiting .....................................................................................................................
Waiting Session Count ...................................................................................................................
Tablespaces Full.....................................................................................................................................
Tablespace Space Used (%)............................................................................................................
Tablespaces Full (dictionary managed).............................................................................................
Tablespace Space Used (%) (dictionary managed) ....................................................................

Tablespaces With Problem Segments................................................................................................
Segments Approaching Maximum Extents.................................................................................
Segments Approaching Maximum Extents Count.....................................................................
Segments Not Able to Extend .......................................................................................................
Segments Not Able to Extend Count ...........................................................................................
Throughput.............................................................................................................................................
All Sessions ......................................................................................................................................
BG Checkpoints (per second) ........................................................................................................
Branch Node Splits (per second)...................................................................................................
Branch Node Splits (per transaction) ...........................................................................................
Consistent Read Blocks Created (per second) ............................................................................
Consistent Read Blocks Created (per transaction) .....................................................................
Consistent Read Changes (per second)........................................................................................
Consistent Read Changes (per transaction) ................................................................................
Consistent Read Gets (per second) ...............................................................................................
Consistent Read Gets (per transaction)........................................................................................
Consistent Read Undo Records Applied (per second) ..............................................................
Consistent Read Undo Records Applied (per transaction).......................................................
Cumulative Logons (per second)..................................................................................................
Cumulative Logons (per transaction) ..........................................................................................
Database Block Changes (per second) .........................................................................................
Database Block Changes (per transaction) ..................................................................................
Database Block Gets (per second).................................................................................................
Database Block Gets (per transaction) .........................................................................................
DBWR Checkpoints (per second) .................................................................................................
Enqueue Deadlocks (per second)..................................................................................................
Enqueue Deadlocks (per transaction) ..........................................................................................
Enqueue Requests (per second) ....................................................................................................
Enqueue Requests (per transaction) .............................................................................................
Enqueue Timeout (per second) .....................................................................................................

Enqueue Timeout (per transaction)..............................................................................................
Enqueue Waits (per second) ..........................................................................................................
Enqueue Waits (per transaction)...................................................................................................
Executes (per second) .....................................................................................................................
Executes Performed without Parses (%)......................................................................................
Full Index Scans (per second)........................................................................................................
Full Index Scans (per transaction) ................................................................................................
Hard Parses (per second) ...............................................................................................................

vi

2-61
2-62
2-62
2-62
2-63
2-63
2-63
2-65
2-65
2-65
2-66
2-66
2-67
2-67
2-68
2-68
2-69
2-69
2-70

2-70
2-71
2-71
2-72
2-72
2-73
2-74
2-74
2-75
2-75
2-76
2-77
2-77
2-78
2-79
2-80
2-81
2-81
2-82
2-82
2-83
2-83
2-84
2-84
2-85
2-86
2-86
2-87



Hard Parses (per transaction)........................................................................................................
Leaf Node Splits (per second) .......................................................................................................
Leaf Node Splits (per transaction) ................................................................................................
Network Bytes (per second) ..........................................................................................................
Number of Transactions (per second)..........................................................................................
Open Cursors (per second) ............................................................................................................
Open Cursors (per transaction).....................................................................................................
Parse Failure Count (per second)..................................................................................................
Parse Failure Count (per transaction) ..........................................................................................
Physical Reads (per second) ..........................................................................................................
Physical Reads (per transaction) ...................................................................................................
Physical Reads Direct (per second) ..............................................................................................
Physical Reads Direct (per transaction) .......................................................................................
Physical Reads Direct Lobs (per second) .....................................................................................
Physical Reads Direct Lobs (per transaction)............................................................................
Physical Writes (per second) .......................................................................................................
Physical Writes (per transaction) ................................................................................................
Physical Writes Direct (per second) ...........................................................................................
Physical Writes Direct (per transaction) ....................................................................................
Physical Writes Direct Lobs (per second) ..................................................................................
Physical Writes Direct Lobs (per transaction)...........................................................................
Recursive Calls (per second)........................................................................................................
Recursive Calls (per transaction) ................................................................................................
Redo Generated (per second) ......................................................................................................
Redo Generated (per transaction)...............................................................................................
Redo Writes (per second) .............................................................................................................
Redo Writes (per transaction)......................................................................................................
Rows Processed (per sort)............................................................................................................
Scans on Long Tables (per second).............................................................................................
Scans on Long Tables (per transaction) .....................................................................................

Session Logical Reads (per second) ............................................................................................
Session Logical Reads (per transaction).....................................................................................
Soft Parse (%) .................................................................................................................................
Sorts to Disk (per second) ............................................................................................................
Sorts to Disk (per transaction) .....................................................................................................
Total Index Scans (per second)....................................................................................................
Total Index Scans (per transaction) ............................................................................................
Total Parses (per second) .............................................................................................................
Total Parses (per transaction) ......................................................................................................
Total Table Scan (per second)......................................................................................................
Total Table Scan (per transaction) ..............................................................................................
Total Table Scans (per second) ....................................................................................................
Total Table Scans (per transaction).............................................................................................
User Calls (%) ................................................................................................................................
User Calls (per second).................................................................................................................
User Calls (per transaction) .........................................................................................................
User Commits (per second) .........................................................................................................

2-88
2-90
2-90
2-91
2-92
2-93
2-94
2-94
2-95
2-95
2-97
2-98

2-99
2-99
2-100
2-100
2-101
2-102
2-103
2-103
2-104
2-105
2-106
2-107
2-108
2-109
2-110
2-112
2-113
2-114
2-115
2-116
2-117
2-118
2-119
2-121
2-121
2-122
2-123
2-125
2-125
2-126

2-126
2-127
2-129
2-129
2-130

vii


User Commits (per transaction) ..................................................................................................
User Rollback Undo Records Applied (per second) ................................................................
User Rollback Undo Records Applied (per transaction).........................................................
User Rollbacks (per second) ........................................................................................................
User Rollbacks (per transaction) .................................................................................................
User Audit.............................................................................................................................................
Audited User..................................................................................................................................
Audited User Host ........................................................................................................................
Audited User Session Count .......................................................................................................
User Block .............................................................................................................................................
Blocking Session Count ................................................................................................................
User Defined Metrics..........................................................................................................................
User Defined Numeric Metric .....................................................................................................
User Defined String Metric ..........................................................................................................
Wait Bottlenecks ..................................................................................................................................
Active Sessions Using CPU .........................................................................................................
Active Sessions Waiting: I/O ......................................................................................................
Active Sessions Waiting: Other ...................................................................................................
Average Instance CPU (%)...........................................................................................................
buffer busy waits (%)....................................................................................................................
CPU Time Delta (sec)....................................................................................................................

db file scattered read (%)..............................................................................................................
db file sequential read (%) ...........................................................................................................
db file single write (%)..................................................................................................................
direct path read (%) ......................................................................................................................
direct path read (lob) (%) .............................................................................................................
direct path write (%) .....................................................................................................................
direct path write (lob) (%) ............................................................................................................
enqueue - other (%).......................................................................................................................
enqueue: DML - contention (%) ..................................................................................................
enqueue: HW, Segment High Water Mark - contention (%) ..................................................
enqueue: ST, Space Transaction - contention (%).....................................................................
enqueue: TM, TX, Transaction - row lock contention (%).......................................................
enqueue: TX mode 4, Transaction - allocate ITL entry (%) .....................................................
enqueue: UL: User-defined - contention (%).............................................................................
free buffer waits (%)......................................................................................................................
Host CPU Utilization (%).............................................................................................................
latch free - other (%)......................................................................................................................
latch: cache buffer chains (%) ......................................................................................................
latch: library cache (%) .................................................................................................................
latch: redo copy (%) ......................................................................................................................
latch: shared pool (%) ...................................................................................................................
library cache load lock (%)...........................................................................................................
library cache lock (%)....................................................................................................................
library cache pin (%) .....................................................................................................................
local write wait (%) .......................................................................................................................
log buffer space (%).......................................................................................................................

viii

2-131

2-132
2-133
2-133
2-134
2-135
2-135
2-136
2-137
2-137
2-137
2-138
2-138
2-139
2-139
2-139
2-139
2-139
2-140
2-140
2-141
2-142
2-143
2-144
2-145
2-146
2-147
2-149
2-150
2-151
2-152

2-153
2-154
2-154
2-155
2-156
2-157
2-158
2-159
2-160
2-161
2-162
2-163
2-163
2-165
2-166
2-167


log file switch (archiving needed) (%) .......................................................................................
log file switch (checkpoint complete) (%)..................................................................................
log file switch completion (%) .....................................................................................................
log file sync (%) .............................................................................................................................
log switch/archive (%) .................................................................................................................
pipe put (%)....................................................................................................................................
row cache lock (%) ........................................................................................................................
SQL*Net break/reset to client (%) ..............................................................................................
SQL*Net break/reset to dblink (%) ............................................................................................
SQL*Net message to client (%)....................................................................................................
SQL*Net message to dblink (%)..................................................................................................
SQL*Net more data from client (%)............................................................................................

SQL*Net more data from dblink (%)..........................................................................................
SQL*Net more data to client (%).................................................................................................
SQL*Net more data to dblink (%)...............................................................................................
Wait Time (%) ................................................................................................................................
write complete waits (%)..............................................................................................................
Wait by Session Count........................................................................................................................
Session Waiting for Event Count ................................................................................................
Waits by Wait Class .............................................................................................................................
Average Users Waiting Count ....................................................................................................
Database Time Spent Waiting (%) ..............................................................................................

3

2-168
2-169
2-169
2-170
2-171
2-172
2-173
2-173
2-175
2-176
2-176
2-177
2-178
2-179
2-180
2-180
2-181

2-182
2-182
2-183
2-183
2-184

Listener
General Status...........................................................................................................................................
Alias......................................................................................................................................................
Security ................................................................................................................................................
SID List.................................................................................................................................................
SNMP Status .......................................................................................................................................
Start Date .............................................................................................................................................
TNS Address .......................................................................................................................................
Trace Level ..........................................................................................................................................
Version .................................................................................................................................................
Load.............................................................................................................................................................
Connections Established (per min)..................................................................................................
Connections Refused (per min)........................................................................................................
Response ....................................................................................................................................................
Response Time (msec) .......................................................................................................................
Status....................................................................................................................................................

Part II
4

3-1
3-1
3-1
3-2

3-2
3-3
3-3
3-3
3-4
3-4
3-4
3-5
3-5
3-5
3-6

Host Metrics

Host
Aggregate Resource Usage Statistics (By Project).............................................................................. 4-1
Cumulative CPU Wait Time(Seconds)............................................................................................ 4-1
Cumulative Data Page Fault Sleep Time(Seconds) ....................................................................... 4-1

ix


Cumulative Major Page Faults......................................................................................................... 4-2
Cumulative Minor Page Faults ........................................................................................................ 4-2
Cumulative Number Character IO (bytes) Read and Written .................................................... 4-3
Cumulative Number Of Blocks Read.............................................................................................. 4-3
Cumulative Number Of Blocks Written ......................................................................................... 4-3
Cumulative Number of Involuntary Context Switches ............................................................... 4-4
Cumulative Number Of Messages Received ................................................................................. 4-4
Cumulative Number Of Messages Sent.......................................................................................... 4-4

Cumulative Number of Signals Received ...................................................................................... 4-5
Cumulative Number of System Calls Made .................................................................................. 4-5
Cumulative Number of Voluntary Context Switches................................................................... 4-6
Cumulative Project Lock-Wait Sleep Time(Seconds) ................................................................... 4-6
Cumulative Project Other Sleep Time(Seconds)............................................................................ 4-6
Cumulative Stop Time(Seconds)...................................................................................................... 4-7
Cumulative Swap Operations .......................................................................................................... 4-7
Cumulative System Mode Time (seconds)..................................................................................... 4-7
Cumulative System Page Fault Sleep Time(Seconds)................................................................... 4-8
Cumulative System Trap Time (seconds)....................................................................................... 4-8
Cumulative Text Page Fault Sleep Time(Seconds)........................................................................ 4-9
Cumulative User Mode Time (seconds) ......................................................................................... 4-9
Number of Processes Owned by Project......................................................................................... 4-9
Project CPU Time (%) ..................................................................................................................... 4-10
Project Process Memory Size (%) .................................................................................................. 4-10
Project's Total Process Heap Size(KiloBytes) .............................................................................. 4-10
Project's Total Process Resident Set Size(KiloBytes) .................................................................. 4-11
Project's Total Process Virtual Memory Size(KiloBytes) ........................................................... 4-11
Status................................................................................................................................................. 4-12
Total Number of Threads in Project's Processes......................................................................... 4-12
Aggregate Resource Usage Statistics(By User) ................................................................................ 4-12
Cumulative CPU Wait Time(Seconds)......................................................................................... 4-12
Cumulative Data Page Fault Sleep Time(Seconds) .................................................................... 4-13
Cumulative Major Page Faults...................................................................................................... 4-13
Cumulative Minor Page Faults ..................................................................................................... 4-13
Cumulative Number Character IO (bytes) Read and Written ................................................. 4-14
Cumulative Number Of Blocks Read........................................................................................... 4-14
Cumulative Number Of Blocks Written ...................................................................................... 4-14
Cumulative Number of Involuntary Context Switches ............................................................ 4-15
Cumulative Number Of Messages Received .............................................................................. 4-15

Cumulative Number Of Messages Sent....................................................................................... 4-16
Cumulative Number of Signals Received ................................................................................... 4-16
Cumulative Number of System Calls Made ............................................................................... 4-16
Cumulative Number of Voluntary Context Switches................................................................ 4-17
Cumulative Stop Time(Seconds)................................................................................................... 4-17
Cumulative Swap Operations ....................................................................................................... 4-17
Cumulative System Mode Time (seconds).................................................................................. 4-18
Cumulative System Page Fault Sleep Time(Seconds)................................................................ 4-18
Cumulative System Trap Time (seconds).................................................................................... 4-19

x


Cumulative Text Page Fault Sleep Time(Seconds).....................................................................
Cumulative User Lock-Wait Sleep Time(Seconds) ....................................................................
Cumulative User Mode Time (seconds) ......................................................................................
Cumulative User Other Sleep Time(Seconds) ............................................................................
Number of Processes Owned by User .........................................................................................
Total Number of Threads in User's Processes ............................................................................
User CPU Time (%) .........................................................................................................................
User Process Memory Size (%)......................................................................................................
User's Total Process Heap Size(KiloBytes) ..................................................................................
User's Total Process Resident Set Size(KiloBytes)......................................................................
User's Total Process Virtual Memory Size(KiloBytes) ...............................................................
Buffer Activity........................................................................................................................................
Buffer Cache Read Hit Ratio (%)...................................................................................................
Buffer Cache Reads (per second) ..................................................................................................
Buffer Cache Write Hit Ratio (%)..................................................................................................
Buffer Cache Writes (per second) .................................................................................................
Physical I/O Reads (per second) .................................................................................................

Physical I/O Writes (per second) .................................................................................................
Physical Reads (per second) ..........................................................................................................
Physical Writes (per second) .........................................................................................................
CPU Usage ..............................................................................................................................................
CPU Idle Time (%) ..........................................................................................................................
CPU Interrupt Time (%) .................................................................................................................
CPU System Time (%) ....................................................................................................................
CPU User Time (%) .........................................................................................................................
CPU Wait Time (%).........................................................................................................................
Disk Activity ..........................................................................................................................................
Average Disk I/O Service Time (ms) ...........................................................................................
Average Disk I/O Wait Time (ms) ...............................................................................................
Average Outstanding Disk I/O Requests ...................................................................................
Average Run Time (ms) .................................................................................................................
Disk Block Writes (per second) .....................................................................................................
Disk Blocks Reads (per second) ....................................................................................................
Disk Reads (per second).................................................................................................................
Disk Utilization (%).........................................................................................................................
Disk Writes (per second) ................................................................................................................
Disk Device Errors ................................................................................................................................
Hard Errors ......................................................................................................................................
Soft Errors.........................................................................................................................................
Total...................................................................................................................................................
Transport Errors ..............................................................................................................................
File Access System Calls ......................................................................................................................
Blocks Read by Directory Search Routine (per second) ............................................................
iget() Calls (per second)..................................................................................................................
lookuppn() Calls (per second) .......................................................................................................
Filesystems..............................................................................................................................................
Filesystem.........................................................................................................................................


4-19
4-19
4-20
4-20
4-20
4-21
4-21
4-22
4-22
4-22
4-23
4-23
4-23
4-24
4-24
4-25
4-25
4-25
4-26
4-26
4-27
4-27
4-28
4-28
4-29
4-29
4-30
4-30
4-31

4-32
4-33
4-33
4-34
4-34
4-35
4-36
4-36
4-37
4-37
4-37
4-38
4-38
4-38
4-39
4-39
4-40
4-40

xi


Filesystem Size (MB).......................................................................................................................
Filesystem Space Available (%).....................................................................................................
Filesystem Utilization (MB) ...........................................................................................................
Inventory.................................................................................................................................................
Kernel Memory......................................................................................................................................
Failed Requests for Large Kernel Memory..................................................................................
Failed Requests for Oversize Kernal Memory ............................................................................
Failed Requests for Small Kernel Memory .................................................................................

KMA Available for Large Memory Requests (Bytes) ................................................................
KMA for Oversize Memory Requests (Bytes).............................................................................
KMA for Small Memory Requests ...............................................................................................
Memory Allocated for Large Memory Requests (Bytes)...........................................................
Memory Allocated for Small Memory Requests (Bytes) ...........................................................
Load..........................................................................................................................................................
CPU in IO-Wait (%).........................................................................................................................
CPU in System Mode (%)...............................................................................................................
CPU in User Mode (%) ...................................................................................................................
CPU Interrupt Time (%) .................................................................................................................
CPU Queue Length ........................................................................................................................
CPU Utilization (%) ........................................................................................................................
Free Memory (%).............................................................................................................................
Longest Service Time (ms) .............................................................................................................
Memory Page Scan Rate (per second) ..........................................................................................
Memory Utilization (%)..................................................................................................................
Page Transfers Rate.........................................................................................................................
Run Queue Length (1 minute average)........................................................................................
Run Queue Length (15 minute average)......................................................................................
Run Queue Length (5 minute average)........................................................................................
Swap Utilization (%) .......................................................................................................................
Total I/O (per second)....................................................................................................................
Total Processes.................................................................................................................................
Total Swap, Kilobytes .....................................................................................................................
Total Users........................................................................................................................................
Used Swap, Kilobytes .....................................................................................................................
Message and Semaphore Activity ......................................................................................................
msgrcv() System Calls (per second) .............................................................................................
semop() System Calls (per second)...............................................................................................
Network Interfaces................................................................................................................................

Network Interface Input Errors (%) ...........................................................................................
Network Interface Collisions (%)..................................................................................................
Network Interface Combined Utilization (%).............................................................................
Network Interface Output Errors (%) ..........................................................................................
Network Interface Read (MB/s) ...................................................................................................
Network Interface Read Utilization (%) ......................................................................................
Network Interface Write (MB/s) ..................................................................................................
Network Interface Write Utilization (%) .....................................................................................
Paging Activity.......................................................................................................................................

xii

4-40
4-41
4-42
4-42
4-42
4-42
4-43
4-43
4-43
4-43
4-44
4-44
4-44
4-45
4-45
4-46
4-46
4-47

4-48
4-48
4-49
4-50
4-50
4-51
4-52
4-52
4-53
4-54
4-54
4-55
4-56
4-56
4-57
4-57
4-58
4-58
4-58
4-59
4-59
4-60
4-60
4-61
4-62
4-62
4-63
4-63
4-64



Address Translation Page Faults (per second) ...........................................................................
Cache Faults (per second) ..............................................................................................................
Copy-on-write Faults (per second)...............................................................................................
Demand Zero Faults (per second) ................................................................................................
igets with Page Flushes(%) ............................................................................................................
Page Faults (per second) ................................................................................................................
Page Faults from Software Lock Requests ..................................................................................
Page-in Requests (per second).......................................................................................................
Page-out Requests (per second) ....................................................................................................
Pages Paged-in (per second)..........................................................................................................
Pages Paged-out (per second) .......................................................................................................
Pages Put on Freelist by Page Stealing Daemon (per second)..................................................
Pages Scanned by Page Stealing Daemon (per second) ............................................................
Transition Faults (per second).......................................................................................................
Process, Inode, File Tables Statistics..................................................................................................
File Table Overflow Occurrences .................................................................................................
Inode Table Overflow Occurrences ..............................................................................................
Maximum Size of Inode Table.......................................................................................................
Maximum Size of Process Table ...................................................................................................
Maximum Size of System File Table.............................................................................................
Process Table Overflow Occurrences...........................................................................................
Size of Inode Table ..........................................................................................................................
Size of Process Table .......................................................................................................................
Size of System File Table ................................................................................................................
Response .................................................................................................................................................
Status.................................................................................................................................................
Swap Area Status...................................................................................................................................
Swap Free .........................................................................................................................................
Swap Size..........................................................................................................................................

Switch/Swap Activity ...........................................................................................................................
Process Context Switches (per second) ........................................................................................
Swapins Transfers (per second) ....................................................................................................
Swapout Transfers (per second) ...................................................................................................
System Swapins (per second) ........................................................................................................
System Swapouts (per second)......................................................................................................
System Calls ...........................................................................................................................................
Characters Transferred by Read System Calls (per second).....................................................
Characters Transferred by Write System Calls (per second) ....................................................
exec() System Calls (per second)...................................................................................................
fork() System Calls (per second) ...................................................................................................
read() System Calls (per second)...................................................................................................
System Calls (per second) ..............................................................................................................
write() System Calls (per second) .................................................................................................
Top Processes..........................................................................................................................................
Command and Arguments ............................................................................................................
CPU Time for Top Processes .........................................................................................................
CPU Utilization for Top Processes (%) ........................................................................................

4-64
4-65
4-65
4-66
4-66
4-67
4-67
4-68
4-69
4-69
4-70

4-71
4-71
4-72
4-72
4-73
4-73
4-74
4-74
4-75
4-75
4-76
4-76
4-76
4-77
4-77
4-77
4-77
4-78
4-79
4-79
4-79
4-80
4-80
4-81
4-81
4-82
4-82
4-83
4-83
4-84

4-84
4-85
4-85
4-86
4-86
4-86

xiii


Memory Utilization for Top Processes (%)..................................................................................
Physical Memory Utilization (KB)................................................................................................
Process User ID................................................................................................................................
Virtual Memory Utilization (KB) ..................................................................................................
TTY Activity ...........................................................................................................................................
Incoming Character Interrupts (per second)...............................................................................
Input Characters Processed by canon()........................................................................................
Modem Interrupt Rate (per second).............................................................................................
Outgoing Character Interrupts (per second)...............................................................................
TTY Output Characters (per second) ...........................................................................................
TTY Raw Input (chars/s) ...............................................................................................................
User Defined Metrics............................................................................................................................
User Defined Numeric Metric .......................................................................................................
User Defined String Metric ............................................................................................................
Users.........................................................................................................................................................
Number of Logons .........................................................................................................................

Part III
5


4-87
4-87
4-88
4-88
4-88
4-89
4-89
4-89
4-90
4-90
4-91
4-91
4-92
4-92
4-92
4-92

Oracle Application Server Metrics

Application Server
Application Response.............................................................................................................................. 5-1
Application URL Response Time (seconds)................................................................................... 5-1
Application URL Status..................................................................................................................... 5-2
OPMN Process Information Metrics .................................................................................................... 5-2
Component CPU Usage (%) ............................................................................................................. 5-3
Component Memory Usage (%) ...................................................................................................... 5-3
Component Memory Usage (MB).................................................................................................... 5-4
Component Start Time (ms since epoch) ........................................................................................ 5-5
Component Up Time (ms) ................................................................................................................ 5-5
Component Up/down Status........................................................................................................... 5-5

Free Memory (%)................................................................................................................................ 5-6
Free Memory (MB) ............................................................................................................................. 5-6
Idle CPU Time (%) ............................................................................................................................. 5-7
Total Memory (MB) ........................................................................................................................... 5-7
Resource Usage ......................................................................................................................................... 5-7
CPU Idle Time (%) ............................................................................................................................. 5-8
CPU Usage (%) ................................................................................................................................... 5-8
Free Memory (%)................................................................................................................................ 5-9
Free Memory (MB) ............................................................................................................................. 5-9
Memory Usage (%) ............................................................................................................................ 5-9
Memory Usage (MB)....................................................................................................................... 5-10
Other CPU Usage (%) ..................................................................................................................... 5-10
Other Memory Usage (%) .............................................................................................................. 5-11
Other Memory Usage (MB) ........................................................................................................... 5-11
Total Memory (MB) ........................................................................................................................ 5-12
Response ................................................................................................................................................. 5-12
UpDown Status ............................................................................................................................... 5-12

xiv


6

Discoverer
Discoverer Components..........................................................................................................................
CPU Usage (%) ...................................................................................................................................
Memory Usage (MB)..........................................................................................................................
Number of Sessions ...........................................................................................................................
Discoverer Plus Sessions ........................................................................................................................
Component Type................................................................................................................................

CPU Usage (%) ...................................................................................................................................
DBUser@DB - EUL .............................................................................................................................
Memory Usage (MB)..........................................................................................................................
OS Process ID......................................................................................................................................
SSO User ..............................................................................................................................................
Discoverer Portlet Provider Sessions ...................................................................................................
Component Type................................................................................................................................
CPU Usage (%) ...................................................................................................................................
DBUser@DB - EUL .............................................................................................................................
Memory Usage (MB)..........................................................................................................................
OS Process ID......................................................................................................................................
SSO User ..............................................................................................................................................
Discoverer Sessions .................................................................................................................................
Component Type................................................................................................................................
CPU Usage (%) ...................................................................................................................................
DBUser@DB - EUL .............................................................................................................................
Memory Usage (MB)..........................................................................................................................
OS Process ID......................................................................................................................................
Private Memory Usage (MB) ............................................................................................................
Shared Memory Usage (MB) ............................................................................................................
SSO User ..............................................................................................................................................
Discoverer Viewer Sessions ...................................................................................................................
Component Type................................................................................................................................
CPU Usage (%) ...................................................................................................................................
DBUser@DB - EUL .............................................................................................................................
Memory Usage (MB)..........................................................................................................................
OS Process ID......................................................................................................................................
SSO User ..............................................................................................................................................
Response ....................................................................................................................................................
UpDown Status ..................................................................................................................................

Total Discoverer CPU Usage ..................................................................................................................
Total Discoverer CPU Usage (%) .....................................................................................................
Total Discoverer Memory Usage ...........................................................................................................
Total Discoverer Memory Usage (MB) ...........................................................................................
Total Number Of Discoverer Plus Sessions ........................................................................................
Total Number Of Discoverer Plus Sessions ...................................................................................
Total Number Of Discoverer Portlet Provider Sessions ...................................................................
Total Number Of Discoverer Portlet Provider Sessions...............................................................
Total Number Of Discoverer Sessions .................................................................................................
Total Number Of Discoverer Sessions ............................................................................................

6-1
6-1
6-1
6-2
6-2
6-2
6-2
6-3
6-3
6-3
6-3
6-3
6-3
6-3
6-4
6-4
6-4
6-4
6-4

6-4
6-5
6-5
6-5
6-5
6-5
6-5
6-5
6-6
6-6
6-6
6-6
6-6
6-6
6-6
6-7
6-7
6-7
6-7
6-8
6-8
6-8
6-9
6-9
6-9
6-9
6-9

xv



Total Number Of Discoverer Viewer Sessions................................................................................ 6-10
Total Number Of Discoverer Viewer Sessions ........................................................................... 6-10

7

Forms
Load.............................................................................................................................................................
Total CPU (%) .....................................................................................................................................
Total Memory (%) ..............................................................................................................................
Total number of users........................................................................................................................
Response ....................................................................................................................................................
ResponseTime(ms) .............................................................................................................................
Status....................................................................................................................................................

8

7-1
7-1
7-1
7-2
7-2
7-3
7-3

HTTP Server
Host Metrics .............................................................................................................................................. 8-1
Name.................................................................................................................................................... 8-1
modplsql_Cache Metrics ........................................................................................................................ 8-1
cacheStatus.value ............................................................................................................................... 8-1

hits.count, ops ..................................................................................................................................... 8-2
hits.percentage.................................................................................................................................... 8-2
modplsql.............................................................................................................................................. 8-2
Name.................................................................................................................................................... 8-2
newMisses.count, ops........................................................................................................................ 8-3
newMisses.percentage....................................................................................................................... 8-3
requests.count ..................................................................................................................................... 8-3
staleMisses.count, ops ....................................................................................................................... 8-4
staleMisses.percentage ...................................................................................................................... 8-4
modplsql_HTTPResponseCodes Metrics............................................................................................ 8-4
HTTP 200s ........................................................................................................................................... 8-4
HTTP 200s percentage ....................................................................................................................... 8-5
HTTP 300s Resolved .......................................................................................................................... 8-5
HTTP 300s resolved percentage....................................................................................................... 8-5
HTTP 400s ........................................................................................................................................... 8-6
HTTP 400s percentage ....................................................................................................................... 8-6
HTTP 500s ........................................................................................................................................... 8-7
HTTP 500s percentage ....................................................................................................................... 8-7
Total HTTP responses........................................................................................................................ 8-8
modplsql_RequestGroupingSQLErrorList Metrics .......................................................................... 8-8
errorCount.count................................................................................................................................ 8-8
lastErrorDate.value ............................................................................................................................ 8-8
lastErrorRequest.value ...................................................................................................................... 8-9
lastErrorText.value............................................................................................................................. 8-9
Name.................................................................................................................................................... 8-9
modplsql_RequestLast10SQLErrorList Metrics.............................................................................. 8-10
errorDate.value................................................................................................................................ 8-10
errorRequest.value .......................................................................................................................... 8-10
errorText.value ................................................................................................................................ 8-10
Name................................................................................................................................................. 8-11


xvi


OHS General Metrics ...........................................................................................................................
Start Time (ms since Epoch) ..........................................................................................................
OHS Module Metrics............................................................................................................................
Active Requests for a Module .......................................................................................................
Request Handling Throughput, for a Module (requests per second) .....................................
Request Handling Time, for a Module (seconds).......................................................................
OHS Process Metrics ............................................................................................................................
Heap Usage (MB) ............................................................................................................................
OHS Server Metrics ..............................................................................................................................
Active HTTP Connections .............................................................................................................
Active HTTP Requests....................................................................................................................
Busy Processes .................................................................................................................................
Connection Duration (seconds).....................................................................................................
Error Rate (%) ..................................................................................................................................
Idle Processes ...................................................................................................................................
Percentage of Busy Processes ........................................................................................................
Request Processing Time (seconds)..............................................................................................
Request Throughput (requests per second) ................................................................................
Response Data Processed (KB per response) ..............................................................................
Response Data Throughput (KB per second)..............................................................................
OHS Virtual Host Metrics ...................................................................................................................
Active Requests for a Virtual Host ...............................................................................................
Request Processing Time for a Virtual Host (seconds)..............................................................
Request Throughput for a Virtual Host (requests per second) ................................................
Response Data Processed for a Virtual Host (KB per response) ..............................................
Response Data Throughput for a Virtual Host (KB per second) .............................................

Virtual Host Type............................................................................................................................
Process Metrics.......................................................................................................................................
Host ...................................................................................................................................................
Name.................................................................................................................................................
Resource Usage ......................................................................................................................................
CPU Idle Time (%) ..........................................................................................................................
CPU Usage (%) ................................................................................................................................
Free Memory (%).............................................................................................................................
Free Memory (MB) ..........................................................................................................................
Memory Usage (%) .........................................................................................................................
Memory Usage (MB).......................................................................................................................
Other CPU Usage (%) .....................................................................................................................
Other Memory Usage (%) ..............................................................................................................
Other Memory Usage (MB) ...........................................................................................................
Total Memory (MB) ........................................................................................................................
Response .................................................................................................................................................
UpDown Status ...............................................................................................................................

9

8-11
8-11
8-11
8-11
8-12
8-12
8-12
8-13
8-13
8-13

8-13
8-14
8-14
8-15
8-15
8-15
8-16
8-17
8-17
8-18
8-18
8-18
8-19
8-19
8-20
8-20
8-21
8-21
8-21
8-21
8-21
8-21
8-22
8-22
8-23
8-23
8-23
8-24
8-24
8-24

8-25
8-25
8-25

Internet File System
Application URL Timing ........................................................................................................................ 9-1
Application URL Response Time (seconds)................................................................................... 9-1

xvii


Application URL Status..................................................................................................................... 9-2
Document Statistics ................................................................................................................................. 9-2
Average Document Size (bytes) ....................................................................................................... 9-2
Total Number of Documents............................................................................................................ 9-3
Total Size of Documents (bytes)....................................................................................................... 9-3
Documents By MIME Type .................................................................................................................... 9-3
Documents .......................................................................................................................................... 9-3
Size of Documents (bytes)................................................................................................................. 9-4
Domain Response .................................................................................................................................... 9-4
Domain Controller Status ................................................................................................................. 9-4
Node Status ......................................................................................................................................... 9-4
Node Status Message......................................................................................................................... 9-5
Status.................................................................................................................................................... 9-5
Load Balanced Application URL Timing............................................................................................. 9-6
Load Balanced Application URL Response Time (seconds)........................................................ 9-6
Load Balanced Application URL Status ......................................................................................... 9-6
Node Statistics .......................................................................................................................................... 9-7
Host Name and IP.............................................................................................................................. 9-7
JVM Free Memory (%)....................................................................................................................... 9-7

JVM Free Memory (MB) .................................................................................................................... 9-8
JVM Threads ....................................................................................................................................... 9-8
JVM Total Memory (MB) .................................................................................................................. 9-9
JVM Used Memory (MB) .................................................................................................................. 9-9
Sessions ................................................................................................................................................ 9-9
Resource Usage ...................................................................................................................................... 9-10
CPU Idle (%) .................................................................................................................................... 9-10
CPU Other (%) ................................................................................................................................. 9-10
CPU Usage (%) ................................................................................................................................ 9-10
Memory Usage (%) ......................................................................................................................... 9-11
Memory Usage (MB)....................................................................................................................... 9-12
Total Memory (MB) ........................................................................................................................ 9-12
Response ................................................................................................................................................. 9-12
Status................................................................................................................................................. 9-12
Sessions By Server (Domain) .............................................................................................................. 9-13
Sessions By Server........................................................................................................................... 9-13
Sessions By Server (Node)................................................................................................................... 9-13
Host Name and IP........................................................................................................................... 9-14
Sessions By Server........................................................................................................................... 9-14
Users......................................................................................................................................................... 9-14
All Users ........................................................................................................................................... 9-15
Average Consumed Quota By All Users (bytes) ........................................................................ 9-15
Average Consumed Quota By Limited Users (bytes)................................................................ 9-15
Average Consumed Quota By Unlimited Users (bytes) ........................................................... 9-15
Consumed Quota By All Users (bytes) ........................................................................................ 9-16
Consumed Quota By Limited Users (bytes)................................................................................ 9-16
Consumed Quota By Unlimited Users (bytes) ........................................................................... 9-16
Users With Limited Quota............................................................................................................. 9-17

xviii



Users With Unlimited Quota.........................................................................................................
Users (With Limited Quota) ................................................................................................................
Average Allocated Quota (bytes)..................................................................................................
Average Consumed Quota (bytes) ...............................................................................................
Consumed (%) .................................................................................................................................
Total Allocated Quota (bytes) .......................................................................................................
Total Consumed Quota (bytes) .....................................................................................................
Users (With Limited Quota) ..........................................................................................................

10

9-17
9-17
9-18
9-18
9-18
9-18
9-19
9-19

JServ
Response ................................................................................................................................................. 10-1
Status................................................................................................................................................. 10-1

11

OC4J
Application Metrics for OC4J Instances ...........................................................................................

Application - Delta EJB Method Execution Time (seconds) .....................................................
Application - Delta EJB Method Invocations ..............................................................................
Application - Delta Request Processing Time (seconds) ...........................................................
Application - Delta Requests Completed ....................................................................................
Application - Delta Servlet, JSP and EJB Time (seconds) ..........................................................
Application - Requests Completed since Startup.......................................................................
Application - Total EJB Method Execution Time (seconds)......................................................
Application - Total EJB Method Invocations ..............................................................................
Application - Total Request Processing Time (seconds) ...........................................................
Application - Total Servlet, JSP and EJB Time (seconds) ..........................................................
OC4J All Instances Metrics .................................................................................................................
OC4J Instances - Active Sessions ..................................................................................................
OC4J Instances - Request Processing Time (seconds)................................................................
OC4J Instances - Requests Per Second .........................................................................................
OC4J Application Metrics....................................................................................................................
Application - Active EJB Methods ................................................................................................
Application - Active Requests .......................................................................................................
Application - Active Sessions ........................................................................................................
Application - EJB Method Execution Rate (per second)............................................................
Application - EJB Method Execution Time (seconds)................................................................
Application - Request Processing Time (seconds) .....................................................................
Application - Requests Per Second...............................................................................................
OC4J EJB Metrics...................................................................................................................................
EJB - Active Methods ......................................................................................................................
EJB - Method Execution Rate (per second)................................................................................
EJB - Method Execution Time (seconds)....................................................................................
Type of EJB .....................................................................................................................................
OC4J EJB Module Metrics .................................................................................................................
EJB Module - Active Methods .....................................................................................................
EJB Module - Method Execution Rate (per second).................................................................

EJB Module - Method Execution Time (seconds) .....................................................................

11-1
11-1
11-1
11-2
11-2
11-2
11-2
11-3
11-3
11-3
11-4
11-4
11-4
11-4
11-5
11-5
11-5
11-6
11-6
11-7
11-7
11-8
11-8
11-9
11-9
11-10
11-10
11-11

11-11
11-11
11-12
11-12

xix


OC4J Instance Metrics ........................................................................................................................
OC4J Instance - Active EJB Methods ..........................................................................................
OC4J Instance - Active Requests .................................................................................................
OC4J Instance - Active Sessions ..................................................................................................
OC4J Instance - Active Transactions ..........................................................................................
OC4J Instance - EJB Method Execution Rate (per second)......................................................
OC4J Instance - EJB Method Execution Time (seconds)..........................................................
OC4J Instance - Heap Usage (MB)..............................................................................................
OC4J Instance - Open JDBC Connections..................................................................................
OC4J Instance - Request Processing Time (seconds) ...............................................................
OC4J Instance - Requests Per Second.........................................................................................
OC4J Instance - Start Time (ms since Epoch) ............................................................................
OC4J JSP Metrics.................................................................................................................................
Is multi-threaded? .........................................................................................................................
JSP - Active Instances (STM only)...............................................................................................
JSP - Active Requests ....................................................................................................................
JSP - Available Instances (STM only) .........................................................................................
JSP - Client Processing Time (seconds) ......................................................................................
JSP - Requests Per Second ............................................................................................................
OC4J Servlet Metrics ..........................................................................................................................
Servlet - Active Requests..............................................................................................................
Servlet - Client Processing Time (seconds)................................................................................

Servlet - Requests Per Second......................................................................................................
OC4J Web Module Metrics................................................................................................................
Web Module - Active Requests ...................................................................................................
Web Module - Active Sessions ....................................................................................................
Web Module - Class Load Time (seconds) ................................................................................
Web Module - Client Time (seconds).........................................................................................
Web Module - Request Processing Time (seconds) .................................................................
Web Module - Requests Per Second...........................................................................................
Resource Usage ....................................................................................................................................
CPU Idle Time (%) ........................................................................................................................
CPU Usage (%) ..............................................................................................................................
Free Memory (%)...........................................................................................................................
Free Memory (MB) ........................................................................................................................
Memory Usage (%) .......................................................................................................................
Memory Usage (MB).....................................................................................................................
Other CPU Usage (%) ...................................................................................................................
Other Memory Usage (%) ............................................................................................................
Other Memory Usage (MB) .........................................................................................................
Total Memory (MB) ......................................................................................................................
Response ...............................................................................................................................................
UpDown Status .............................................................................................................................

12

11-13
11-13
11-13
11-14
11-14
11-14

11-15
11-15
11-16
11-16
11-17
11-17
11-17
11-17
11-18
11-18
11-19
11-19
11-20
11-20
11-20
11-21
11-22
11-22
11-22
11-23
11-23
11-24
11-24
11-25
11-25
11-25
11-25
11-26
11-26
11-26

11-27
11-27
11-28
11-28
11-28
11-29
11-29

OID LDAP Server
(Critical Events)Security Events ......................................................................................................... 12-1
Event Name...................................................................................................................................... 12-1

xx


Event Result .....................................................................................................................................
Event Time .......................................................................................................................................
Instance Number .............................................................................................................................
Process ID .........................................................................................................................................
Sample ID .........................................................................................................................................
User DN ............................................................................................................................................
(Critical Events)System Resource Events .........................................................................................
Event Name......................................................................................................................................
Instance Number .............................................................................................................................
Last Event Time ...............................................................................................................................
Number of Event Occurence .........................................................................................................
Process ID .........................................................................................................................................
Sample ID .........................................................................................................................................
(Resource Statistics)LDAP Server and System Memory ...............................................................
Date and Time Stamp .....................................................................................................................

Instance Number .............................................................................................................................
LDAP Server's average memory growth (%)..............................................................................
Sample ID .........................................................................................................................................
System's Total Free Physical Memory (KB).................................................................................
(Resource Statistics)LDAP Server's Data Base Usage ....................................................................
Active Data Base Sessions ..............................................................................................................
Date and Time Stamp .....................................................................................................................
Instance Number .............................................................................................................................
Open Data Base Sessions................................................................................................................
Sample ID .........................................................................................................................................
Configuration sets of LDAP Server ...................................................................................................
Configuration set number..............................................................................................................
Max concurrent DB conn ...............................................................................................................
Non SSL port number.....................................................................................................................
Number of server process ..............................................................................................................
SSL authentication type..................................................................................................................
SSL enabled ......................................................................................................................................
SSL port number..............................................................................................................................
SSL Version ......................................................................................................................................
SSL wallet URL ................................................................................................................................
Directory Integration Profiles.............................................................................................................
Execution Errors ..............................................................................................................................
Execution Status ..............................................................................................................................
Last Applied Change Number ......................................................................................................
Last Execution Time........................................................................................................................
Operation..........................................................................................................................................
Schedule (secs).................................................................................................................................
State ...................................................................................................................................................
Type...................................................................................................................................................
Directory Integration Server ...............................................................................................................

Directory Integration Server Host ................................................................................................
Downtime Count.............................................................................................................................

12-1
12-1
12-1
12-2
12-2
12-2
12-2
12-2
12-2
12-2
12-2
12-3
12-3
12-3
12-3
12-3
12-3
12-3
12-4
12-4
12-4
12-4
12-4
12-4
12-4
12-5
12-5

12-5
12-5
12-5
12-5
12-5
12-6
12-6
12-6
12-6
12-6
12-6
12-6
12-6
12-6
12-7
12-7
12-7
12-7
12-7
12-7

xxi


Instance .............................................................................................................................................
LDAP Server ....................................................................................................................................
Start Time .........................................................................................................................................
LDAP All Instance IDs.........................................................................................................................
Instance Number .............................................................................................................................
LDAP Entry Cache Hit Ratio...............................................................................................................

Date and Time Stamp .....................................................................................................................
Instance Number .............................................................................................................................
Process ID .........................................................................................................................................
Sample ID .........................................................................................................................................
Server Entry Cache Hit Ratio ........................................................................................................
LDAP Load and Response ...................................................................................................................
Date and Time Stamp .....................................................................................................................
Instance Number .............................................................................................................................
Sample ID .........................................................................................................................................
Server Average Response Time (in Milliseconds)......................................................................
Server Load ......................................................................................................................................
LDAP Logon Session Statistics...........................................................................................................
Date and Time Stamp .....................................................................................................................
Instance Number .............................................................................................................................
Sample ID .........................................................................................................................................
Total LDAP Logon Sessions ........................................................................................................
LDAP Operations profile...................................................................................................................
Completed Add Operations ........................................................................................................
Completed Compare Operations................................................................................................
Completed Delete Operations .....................................................................................................
Completed Login Operations ......................................................................................................
Completed Modify Operations ...................................................................................................
Completed Search Operations.....................................................................................................
Date and Time Stamp ...................................................................................................................
Instance Number ...........................................................................................................................
Sample ID .......................................................................................................................................
LDAP Server Response ......................................................................................................................
Status...............................................................................................................................................
Total Number.................................................................................................................................
LDAP Server Total Memory Usage ..................................................................................................

Total Size (in KB)...........................................................................................................................
LDAP Server Total User Sessions ....................................................................................................
Total Users Sessions......................................................................................................................
Running instances of LDAP Replication Server...........................................................................
Config Set .......................................................................................................................................
Downtime Count...........................................................................................................................
Instance ...........................................................................................................................................
Oracle Directory Server ................................................................................................................
Start Time .......................................................................................................................................
Running instances of LDAP Server .................................................................................................
Config Set Number .......................................................................................................................

xxii

12-7
12-7
12-7
12-7
12-7
12-7
12-8
12-8
12-8
12-8
12-8
12-8
12-8
12-8
12-9
12-9

12-9
12-9
12-9
12-9
12-9
12-10
12-10
12-10
12-10
12-10
12-10
12-10
12-11
12-11
12-11
12-11
12-11
12-11
12-11
12-11
12-12
12-12
12-12
12-12
12-12
12-12
12-12
12-12
12-13
12-13

12-13


Downtime Count...........................................................................................................................
Host Name .....................................................................................................................................
Instance Number ...........................................................................................................................
Port Number ..................................................................................................................................
Up Since..........................................................................................................................................
Stopped instances of LDAP Server..................................................................................................
Config Set Number .......................................................................................................................
Host Name .....................................................................................................................................
Instance Number ...........................................................................................................................

13

12-13
12-13
12-13
12-13
12-13
12-14
12-14
12-14
12-14

Portal
Database Instance..................................................................................................................................
Instance Name .................................................................................................................................
Start Time .........................................................................................................................................
Version ..............................................................................................................................................

Database Portlet Metrics ......................................................................................................................
Cache Hits ........................................................................................................................................
Count of HTTP 200 Response codes.............................................................................................
Count of HTTP 400 Response codes.............................................................................................
Count of HTTP 500 Response codes.............................................................................................
Count of requests which timed out ..............................................................................................
Count of Resolved HTTP 300 Response codes ...........................................................................
Count of Unresolved HTTP 300 Response codes .......................................................................
Database Portlet Average Time (msec) ........................................................................................
Database Portlet Maximium Time (msec) ...................................................................................
Database Portlet Minimum Time (msec) .....................................................................................
Last Response Code ........................................................................................................................
Requests............................................................................................................................................
Database Providers Metrics.................................................................................................................
Cache Hits ........................................................................................................................................
Count of HTTP 200 Response codes.............................................................................................
Count of HTTP 400 Response codes.............................................................................................
Count of HTTP 500 Response codes.............................................................................................
Count of requests which timed out ..............................................................................................
Count of Resolved HTTP 300 Response codes ...........................................................................
Count of Unresolved HTTP 300 Response codes .......................................................................
Database Provider Portlets Average Time (msec)......................................................................
Database Provider Portlets Maximium Time (msec) ...............................................................
Database Provider Portlets Minimum Time (msec).................................................................
Database Provider Status .............................................................................................................
Offline .............................................................................................................................................
Percentage of Database Provider HTTP 500 Response codes.................................................
Requests..........................................................................................................................................
General Page Engine Metrics............................................................................................................
Average Queue Length ................................................................................................................

Average Time in Page Engine Queue (msec)............................................................................
Cache Hits ......................................................................................................................................

13-1
13-1
13-1
13-2
13-2
13-2
13-2
13-3
13-3
13-4
13-4
13-4
13-5
13-5
13-5
13-6
13-6
13-7
13-7
13-7
13-7
13-8
13-8
13-8
13-9
13-9
13-10

13-11
13-11
13-12
13-12
13-13
13-13
13-14
13-14
13-14

xxiii


Percentage of Requests that were serviced by the cache.........................................................
Percentage of Requests Timing Out in the Page Engine Queue ............................................
Requests for cache enabled pages...............................................................................................
Requests to the Cache ...................................................................................................................
Total Page Requests ......................................................................................................................
Page Engine Response Code Metrics ..............................................................................................
Percentage of http 200 responses ................................................................................................
Percentage of http 300 Resolved responses...............................................................................
Percentage of http 300 Unresolved responses ..........................................................................
Percentage of http 400 responses ................................................................................................
Percentage of http 500 responses ................................................................................................
Timeouts .........................................................................................................................................
Total http 200 responses...............................................................................................................
Total http 300 Resolved responses..............................................................................................
Total http 300 Unresolved responses .........................................................................................
Total http 400 responses...............................................................................................................
Total http 500 responses...............................................................................................................

Total requests.................................................................................................................................
Unresolved Redirects....................................................................................................................
Portal Homepage Metric ....................................................................................................................
Homepage Download (msec)......................................................................................................
Status...............................................................................................................................................
Portal Metadata Repository Version Metric...................................................................................
Portal Metadata Repository Version ..........................................................................................
Response Metric ..................................................................................................................................
Status...............................................................................................................................................
Syndication Server Status Metric.....................................................................................................
Syndication Server Status ............................................................................................................
Top Level Monitoring Status Metric................................................................................................
Top Level Monitoring Status.......................................................................................................
Ultra Search Status Metric .................................................................................................................
Ultra Search Status ........................................................................................................................
Web Portlet Metrics.............................................................................................................................
Cache Hits ......................................................................................................................................
Count of HTTP 200 Response codes...........................................................................................
Count of HTTP 400 Response codes...........................................................................................
Count of HTTP 500 Response codes...........................................................................................
Count of requests which timed out ............................................................................................
Count of Resolved HTTP 300 Response codes .........................................................................
Count of Unresolved HTTP 300 Response codes .....................................................................
Last Response Code ......................................................................................................................
Requests..........................................................................................................................................
Web Portlet Average Time (msec) ..............................................................................................
Web Portlet Maximium Time (msec) .........................................................................................
Web Portlet Minimum Time (msec) ...........................................................................................
Web Providers Metrics .......................................................................................................................
Cache Hits ......................................................................................................................................


xxiv

13-15
13-15
13-16
13-16
13-16
13-17
13-17
13-17
13-18
13-18
13-18
13-19
13-19
13-19
13-20
13-20
13-21
13-21
13-21
13-22
13-22
13-22
13-23
13-23
13-23
13-23
13-24

13-24
13-25
13-25
13-25
13-25
13-26
13-26
13-26
13-27
13-27
13-27
13-28
13-28
13-29
13-29
13-29
13-30
13-30
13-30
13-31


Count of HTTP 200 Response codes...........................................................................................
Count of HTTP 400 Response codes...........................................................................................
Count of HTTP 500 Response codes...........................................................................................
Count of requests which timed out ............................................................................................
Count of Resolved HTTP 300 Response codes .........................................................................
Count of Unresolved HTTP 300 Response codes .....................................................................
Offline .............................................................................................................................................
Percentage of Web Provider HTTP 500 Response codes.........................................................

Requests..........................................................................................................................................
Web Provider Portlets Average Time (msec)............................................................................
Web Provider Portlets Maximium Time (msec) .......................................................................
Web Provider Portlets Minimum Time (msec).........................................................................
Web Provider Status .....................................................................................................................

14

13-31
13-31
13-32
13-32
13-32
13-33
13-33
13-34
13-34
13-35
13-35
13-36
13-37

Reports Server
Cluster Information ..............................................................................................................................
Current Jobs .....................................................................................................................................
Failed Jobs ........................................................................................................................................
Finished Jobs ....................................................................................................................................
Response Time (ms) ........................................................................................................................
Scheduled Jobs.................................................................................................................................
Current Jobs............................................................................................................................................

Job Name ..........................................................................................................................................
Output Format.................................................................................................................................
Output Type.....................................................................................................................................
Owner ...............................................................................................................................................
Queued At ........................................................................................................................................
Started At..........................................................................................................................................
Status.................................................................................................................................................
Engine Information...............................................................................................................................
Engines..............................................................................................................................................
Running ............................................................................................................................................
Failed Jobs...............................................................................................................................................
Finished At .......................................................................................................................................
Job Name ..........................................................................................................................................
Output Format.................................................................................................................................
Output Type.....................................................................................................................................
Owner ...............................................................................................................................................
Queued At ........................................................................................................................................
Started At..........................................................................................................................................
Status.................................................................................................................................................
Finished Jobs..........................................................................................................................................
Finished At .......................................................................................................................................
Job Name ..........................................................................................................................................
Output Format.................................................................................................................................
Output Type.....................................................................................................................................
Owner ...............................................................................................................................................

14-1
14-1
14-1
14-1

14-1
14-1
14-1
14-1
14-2
14-2
14-2
14-2
14-2
14-2
14-2
14-2
14-2
14-2
14-2
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-3
14-4

xxv