Oracle Enterprise Manager Event Test Reference Manual -- Contents

Base Event Tests

User-Defined Event Test

User-Defined SQL Event Test

Microsoft® SQL Server Event Test

Common Node Event Tests

Descriptions of Base and Common Node Event Tests

Alert (Data Gatherer)

HTTP Server UpDown for Oracle9iAS Release 2 (9.0.2)

UpDown (Data Gatherer)

UpDown (Node)

UpDown (SQL Server)

Web Cache UpDown

Summary of Database Event Tests

Descriptions of Database Event Tests

AQ Expired Messages Count

AQ Ready Messages Count

AQ Waiting Messages Count

Archive Full

Archive Full (%)

Archiver Hung

Average File Read Time

Average File Write Time

Average Redo Write Size Per Second

Average Redo Write Size Per Transaction

Average Rows Per Sort

Commits Per Transaction

Data Block Corruption

Data Dictionary Hit %

Data Dictionary Miss %

Data Guard Actual Apply Delay

Data Guard Data Not Applied

Data Guard Logs Not Applied

Data Guard Logs Not Shipped

Data Guard Potential Data Loss

Deferred Transactions

Disk I/O

Disk Sorts Per Second

Disk Sorts Per Transaction

Dump Full

Dump Full (%)

Error Transactions

Executes without Parses %

Failed Jobs

Fast Segment Growth

Free Buffer Waits

Global Cache Blocks Corrupt

Global Cache Blocks Lost

Global Cache Converts

Global Cache CR Request

Logical Reads Per Second

Logical Reads Per Transaction

Logons Per Second

Logons Per Transaction

Maximum Extents

Multiple Extents

Network Reads Per Second

Parses (Hard) Per Second

Parses (Hard) Per Transaction

Parses (Total) Per Second

Parses (Total) Per Transaction

Physical Reads Per Second

Physical Reads Per Transaction

Physical Writes Per Second

Physical Writes Per Transaction

Probe

Process Limit

Recursive Calls Per Second

Recursive Calls Per Transaction

Redo Log Allocation Hit %

Redo No Wait %

Redo Writes Per Second

Redo Writes Per Transaction

Response Time Per Execution

Response Time Per Transaction

Rollback Contention

Rollbacks Per Second

Rollbacks Per Transaction

Suspended Session Count

SysStat Table

SysStat Table Delta

Table Scans (Long) Per Second

Table Scans (Long) Per Transaction

Table Scans (Total) Per Second

Table Scans (Total) Per Transaction

Tablespace Full

Transactions Per Second

User Calls Per Second

User Calls Per Transaction

User Limit

User-Defined SQL Event Test

Wait by Session Count

Wait by Time

Summary of Compaq Tru64 Event Tests

Descriptions of Compaq Tru64 Event Tests

Summary of HP-UX Event Tests

Descriptions of HP-UX Event Tests

Available (KB)

Average CPU Load (1 Minute)

Average CPU Load (5 Minutes)

Average CPU Load (15 Minutes)

Block I/O Reads (#/s)

Block I/O Writes (#/s)

Calls to Syscall() (#/s)

Context Switches (#/s)

Device Interrupts (#/s)

Fork System Calls (#/s)

Number of Block Input Operations

Number of Block Output Operations

Number of Characters Read/Written

Number of Message Queues in Use

Number of Messages Received

Number of Messages Sent

Number of Page Faults Requiring Disk Access

Number of Page Reclaims

Number of Semaphore Identifiers in Use

Number of Shared Memory Segments in Use

Number of System Calls

Number of System Message Headers

Pages Swapped In (#/s)

Pages Swapped Out (#/s)

Percent Memory Used

Physical I/O Reads (#/s)

Physical I/O Writes (#/s)

Read System Calls (#/s)

Write System Calls (#/s)

Summary of IBM AIX Event Tests

Descriptions of IBM AIX Event Tests

Summary of Linux Event Tests

Descriptions of Linux Event Tests

Summary of Solaris Event Tests

Descriptions of Solaris Event Tests

Average Response Time (ms)

Average Service Time (ms)

Block IO Reads (#/s)

Block IO Writes (#/s)

Logical IO Reads (#/s)

Logical IO Writes (#/s)

Maj Faults (#/s)

Incoming Errors (#/s)

Incoming Packets (#/s)

Outgoing Errors (#/s)

Outgoing Packets (#/s)

Page Ins (#/s)

Page Outs (#/s)

Pages Paged In (#/s)

Pages Paged Out (#/s)

Percent Memory Used

Physical I/O Reads (#/s)

Physical I/O Writes (#/s)

System Call Forks (#/s)

System Call VForks (#/s)

System Calls (#/s)

System Interrupts (#/s)

Summary of Windows NT Event Tests

Descriptions of Windows NT Event Tests

% Committed Bytes In Use

% Privileged Time (Process Class)

% Privileged Time (Processor Class)

% Processor Time (Process Class)

% Processor Time (Processor Class)

% Registry Quota In Use

% Total DPC Time

% Total Interrupt Time

% Total Privileged Time

% Total Processor Time

% Total User Time

% Usage

% User Time (Process Class)

% User Time (Processor Class)

Average Response Time (ms)

Avg. Disk Bytes/Read

Avg. Disk Bytes/Transfer

Avg. Disk Bytes/Write

Avg. Disk sec/Read

Avg. Disk sec/Transfer

Current Disk Queue Length

Demand Zero Faults/sec

Exception Dispatches/sec

Fast Read Not Possibles/sec

Fast Read Resource Misses/sec

Fast Reads/sec

File Control Bytes/sec

File Control Operations/sec

File Data Operations/sec

File Read Bytes/sec

File Read Operations/sec

File Write Bytes/sec

File Write Operations/sec

Floating Emulations/sec

Free Megabytes

Free System Page Table Entries

Handle Count

Interrupts/sec

Lazy Write Flushes/sec

Packets Outbound Discarded

Packets Outbound Errors

Packets Received/sec

Packets Received Discarded

Packets Received Errors

Packets Received Non-Unicast/sec

Packets Received Unicast/sec

Packets Received Unknown

Packets Sent/sec

Packets Sent Non-Unicast/sec

Packets Sent Unicast/sec

Page Faults/sec (Memory Class)

Page Faults/sec (Process Class)

Pool Nonpaged Bytes (Memory Class)

Pool Nonpaged Bytes (Process Class)

Pool Paged Allocs

Pool Paged Bytes (Memory Class)

Pool Paged Bytes (Process Class)

Pool Paged Resident Bytes

Private Bytes

Processes

Processor Queue Length

System Cache Resident Bytes

System Calls/sec

System Code Resident Bytes

System Code Total Bytes

System Driver Resident Bytes

System Driver Total Bytes

Thread Count

Threads

Total APC Bypasses/sec

Total DPC Bypasses/sec

Total DPC Rate

Total DPCs Queued/sec

Total Interrupts/sec

Transition Faults/sec

Virtual Bytes

Working Set

Write Copies/sec

Summary of Applications Event Tests

Descriptions of Applications Event Tests

Concurrent Manager Disk Free

Concurrent Manager UpDown

CRM Waiting on a Lock

ICM Waiting on a Lock

Inactive Request Pending

Pending Concurrent Request Backlog

Request Error Rate

Request Pending Time

Request Warning Rate

Run Alone Request Submitted

Unresponsive Concurrent Manager

Descriptions of Applications Event Tests for V8.1.6 and Earlier Agents

Concurrent Manager UpDown (for V8.1.6 and Earlier Agents)

CRM Waiting on a Lock (for V8.1.6 and Earlier Agents)

ICM Waiting on a Lock (for V8.1.6 and Earlier Agents)

Inactive Request Pending (for V8.1.6 and Earlier Agents)

Pending Concurrent Request Backlog (for V8.1.6 and Earlier Agents)

Request Error Rate (for V8.1.6 and Earlier Agents)

Request Pending Time (for V8.1.6 and Earlier Agents)

Request Warning Rate (for V8.1.6 and Earlier Agents)

Run Alone Request Submitted (for V8.1.6 and Earlier Agents)

Summary of SAP Event Tests

Descriptions of SAP Event Tests

Bad Buffer Quality

Bad Response Time

Extended Memory Too Small

In-Memory Roll Area Too Small

In-Memory Page Area Too Small

Summary of HTTP Server Event Tests

Descriptions of HTTP Server Event Tests

Bytes per Second

Requests per Second

Total Servers

Summary of Oracle9iAS Release 2 (9.0.2) Event Tests

Descriptions of Oracle9iAS Release 2 (9.0.2) Event Tests

Enterprise Manager Web Site Event Test

EM Web Site UpDown

HTTP Server Event Tests

Connection Creation Time (sec)

Error Rate (%)

HTTP Server UpDown

Request Processing Time (sec)

OC4J Event Test

OC4J UpDown

Web Cache Event Test

Web Cache UpDown

Apache JServ Event Test

JServ UpDown

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

2 Oracle Database Event Tests

3 Compaq Tru64 Event Tests

4 HP-UX Event Tests

5 IBM AIX Event Tests

6 Linux Event Tests

7 Solaris Event Tests

8 Windows NT Event Tests

9 Management Pack for Oracle Applications Event Tests

10 SAP Event Tests

11 HTTP Server Event Tests

12 Oracle9iAS Release 2 (9.0.2) Event Tests