Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Performance Overview

• 1.1 Introduction to Oracle Application Server Performance
  • 1.1.1 Performance Terms
• 1.2 What Is Performance Tuning?
  • 1.2.1 Response Time
  • 1.2.2 System Throughput
  • 1.2.3 Wait Time
  • 1.2.4 Critical Resources
  • 1.2.5 Effects of Excessive Demand
  • 1.2.6 Adjustments to Relieve Problems
• 1.3 Performance Targets
  • 1.3.1 User Expectations
  • 1.3.2 Performance Evaluation
• 1.4 Performance Methodology
  • 1.4.1 Factors in Improving Performance

2 Monitoring Oracle Application Server

• 2.1 Oracle Enterprise Manager 10g Application Server Control Console
• 2.2 Oracle Application Server Built-in Performance Metrics
• 2.3 Centralized Management of Oracle Application Server Instances
• 2.4 Native Operating System Performance Commands
• 2.5 Network Performance Monitoring Tools

3 Top Performance Areas

• 3.1 Top Performance Areas
  • 3.1.1 Ensure Sufficient Hardware Resources
  • 3.1.2 Ensure Sufficient Java Heap for OC4J
  • 3.1.3 Tune the JVM Garbage Collection Options
  • 3.1.4 Reuse Database Connections
  • 3.1.5 Specify Sufficient Oracle HTTP Server Connections
  • 3.1.6 Enable Statement Caching for Data Sources
  • 3.1.7 Verify Database Tuning
  • 3.1.8 Verify Logging Levels
  • 3.1.9 Reuse EJB Instances
• 3.2 Advanced Performance Areas
  • 3.2.1 Managing Concurrency and Limiting Connections
  • 3.2.2 Load Balancing
  • 3.2.3 Using the -XX:AppendRatio Option (on Standalone OC4J)

4 Additional Performance Areas

• 4.1 Improving TopLink Performance
• 4.2 Improving JTA Performance
  • 4.2.1 Configuring Two-Phase Commit Logging for Performance
  • 4.2.2 Configuring JTA Data Sources for Performance
  • 4.2.3 Monitoring JTA Resources
• 4.3 Improving EJB Performance
  • 4.3.1 Improving MDB Performance
  • 4.3.2 Improving EJB CMP 2.1 Performance

5 Optimizing PL/SQL Performance

6 Optimizing Oracle HTTP Server

• 6.1 Configuring Oracle HTTP Server Directives
  • 6.1.1 How Persistent Connections Can Reduce httpd Process Availability
• 6.2 Oracle HTTP Server Logging Options
  • 6.2.1 Access Logging
  • 6.2.2 Configuring the HostNameLookups Directive
  • 6.2.3 Error logging
• 6.3 Oracle HTTP Server Security Performance Considerations
  • 6.3.1 Oracle HTTP Server Secure Sockets Layer (SSL) Performance Issues
  • 6.3.2 Oracle HTTP Server Port Tunneling Performance Issues
• 6.4 Oracle HTTP Server Performance Tips
  • 6.4.1 Analyze Static Versus Dynamic Requests
  • 6.4.2 Analyze Time Differences Between Oracle HTTP Server and OC4J Servers
  • 6.4.3 Beware of a Single Data Point Yielding Misleading Results

7 Oracle BPEL Process Manager Performance Tuning

• 7.1 Performance Tuning Overview
  • 7.1.1 Domain and Process Configuration Property Settings
  • 7.1.2 Durable and Transient Processes
  • 7.1.3 One-Way and Two-Way Invocations
  • 7.1.4 Idempotent Activities
  • 7.1.5 In-Flight Database Storage
  • 7.1.6 JTA Transactions for Two-way Invocations
  • 7.1.7 BPEL Threading Model
• 7.2 Process Level Performance Settings
  • 7.2.1 completionPersistLevel BPEL Property
  • 7.2.2 completionPersistPolicy BPEL Property
  • 7.2.3 idempotent BPEL Property
  • 7.2.4 inMemoryOptimization BPEL Property
  • 7.2.5 nonBlockingInvoke BPEL Property
• 7.3 Tables Impacted By Instance Data Growth
• 7.4 Domain Level Performance Tuning
  • 7.4.1 Oracle BPEL Control Properties That Cannot Be Edited
  • 7.4.2 auditDetailThreshold BPEL Property
  • 7.4.3 auditLevel BPEL Property
  • 7.4.4 bpelcClasspath BPEL Property
  • 7.4.5 datasourceJndi BPEL Property
  • 7.4.6 deliveryPersistPolicy BPEL Property
  • 7.4.7 dspAgentDelay BPEL Property
  • 7.4.8 dspInvokeAllocFactor BPEL Property
  • 7.4.9 dspMaxRequestDepth BPEL Property
  • 7.4.10 dspMaxThreads BPEL Property
  • 7.4.11 dspMinThreads BPEL Property
  • 7.4.12 expirationMaxRetry BPEL Property
  • 7.4.13 idempotentThreshold BPEL Property
  • 7.4.14 instanceKeyBlockSize BPEL Property
  • 7.4.15 instCacheHighWatermark BPEL Property
  • 7.4.16 instCacheLowWatermark BPEL Property
  • 7.4.17 instCachePolicy BPEL Property
  • 7.4.18 invokerQueueConnectionPoolMinSize BPEL Property
  • 7.4.19 largeDocumentThreshold BPEL Property
  • 7.4.20 minBPELWait BPEL Property
  • 7.4.21 optCacheOn BPEL Property
  • 7.4.22 optIdempotentRouting BPEL Property
  • 7.4.23 optSoapShortcut BPEL Property
  • 7.4.24 processCheckSecs BPEL Property
  • 7.4.25 relaxBpelAssignRules BPEL Property
  • 7.4.26 slowPerfThreshold BPEL Property
  • 7.4.27 statsLastN BPEL Property
  • 7.4.28 syncMaxWaitTime BPEL Property
  • 7.4.29 txDatasourceJndi BPEL Property
  • 7.4.30 uddiLocation BPEL Property
  • 7.4.31 validateXML BPEL Property
  • 7.4.32 workerQueueConnectionPoolMinSize BPEL Property
• 7.5 Tuning OC4J for Oracle BPEL
  • 7.5.1 Tuning JTA Transaction Timeout for Oracle BPEL Process Manager
  • 7.5.2 Oracle BPEL Server EJB Configuration
  • 7.5.3 Configuring Data Sources for Oracle BPEL
• 7.6 Java Virtual Machine Performance Tuning for Oracle BPEL Server
• 7.7 Dehydration Store Database Performance Tuning
• 7.8 Summary

8 Oracle Business Activity Monitoring Performance

• 8.1 Managing the Redo Log Files
• 8.2 Avoiding Frequent Log Switches and Checkpoints
• 8.3 Tuning the System Global Area
• 8.4 Database Re-Organization in the Presence of Deletion Activity
• 8.5 Configuring Multiple Plan Monitor Services and Enterprise Links

9 Oracle Application Server Wireless Messaging Server Performance Tuning

• 9.1 Configuring Oracle Application Server Wireless Messaging Server for High Performance
  • 9.1.1 Overview
  • 9.1.2 Database Tuning and OS Tuning
  • 9.1.3 Optimizing Performance in a Multi-RAC Environment
  • 9.1.4 Messaging Server Configuration
• 9.2 Factors Affecting Messaging Server Performance
  • 9.2.1 Sequencing Cache for trans_mid and trand_did Index
  • 9.2.2 Forcing Use of Index on Table trans_ids
  • 9.2.3 Changing the Navigation Mode
  • 9.2.4 Database Tuning
  • 9.2.5 Multiple Queues with Node Affinity
  • 9.2.6 ASSM Tablespace
  • 9.2.7 Load Balancing
  • 9.2.8 Number of Enqueue and Dequeue Threads
  • 9.2.9 DB Parameter aq_tm_processes
  • 9.2.10 RAC Interconnect on RHEL4
• 9.3 Handling RAC Instance Failure
• 9.4 RAC Reconfiguration
  • 9.4.1 Adding or Removing RAC Nodes
  • 9.4.2 Adding or Removing Mid-Tiers
• 9.5 Test Scenario and Result
  • 9.5.1 Setup Details
  • 9.5.2 One-way Test Scenario
  • 9.5.3 Two-way Test Scenario

A Monitoring Using Built-in Performance Tools

• A.1 Summary of Oracle Application Server Built-in Performance Metrics
• A.2 Viewing Performance Metrics Using AggreSpy with Basic Installation
  • A.2.1 Using the AggreSpy Display
• A.3 Viewing Performance Metrics Using AggreSpy with Web Server
  • A.3.1 Using the AggreSpy Display with Web Server
  • A.3.2 AggreSpy URL With a Proxy Server with Web Server
  • A.3.3 AggreSpy URL and Access Control with Web Server
  • A.3.4 AggreSpy Limitation When Using Load Balancing With Multiple Instances
• A.4 Viewing Performance Metrics Using dmstool
  • A.4.1 Access Control for dmstool
  • A.4.2 Using dmstool to List the Names of All Metrics
  • A.4.3 Using dmstool to Report Values for Specific Performance Metrics
  • A.4.4 Using dmstool With the Interval and Count Options
  • A.4.5 Using dmstool to Report All Metrics with Metric Values
  • A.4.6 Using dmstool to Report All Metrics with Metric Values in XML Format
  • A.4.7 Using dmstool to Reset Metric Values
  • A.4.8 Using dmstool to View Metrics on a Remote Oracle Application Server System
• A.5 Viewing Performance Metrics Using AggreSpy (for Standalone OC4J)
• A.6 Using Built-in Performance Metrics on Windows Systems

B Instrumenting Applications With DMS

• B.1 Introducing DMS Performance Metrics
  • B.1.1 Instrumenting Applications With DMS Metrics
  • B.1.2 Monitoring DMS Metrics
  • B.1.3 Understanding DMS Terminology (Nouns and Sensors)
  • B.1.4 DMS Naming Conventions
• B.2 Adding DMS Instrumentation To Java Applications
  • B.2.1 Including DMS Imports
  • B.2.2 Organizing Performance Data
  • B.2.3 Defining and Using Metrics for Timing
  • B.2.4 Defining and Using Metrics for Counting
  • B.2.5 Defining and Using Metrics for Recording Status Information (State Sensors)
• B.3 Validating and Testing Applications Using DMS Metrics
  • B.3.1 Validating DMS Metrics
  • B.3.2 Testing DMS Metrics For Efficiency
• B.4 Understanding DMS Security Considerations
• B.5 Conditional Instrumentation Using DMS Sensor Weight
• B.6 Dumping DMS Metrics To Files
• B.7 Resetting and Destroying Sensors
• B.8 DMS Coding Recommendations
  • B.8.1 Isolating Expensive Intervals Using PhaseEvent Metrics
• B.9 Using A High Resolution Clock To Increase DMS Precision
  • B.9.1 Configuring DMS Clocks for Reporting Time for OC4J (Java)
  • B.9.2 Configuring DMS Clocks for Reporting Time for Oracle HTTP Server
• B.10 Rolling Up DMS Data for Descendent Nouns

C Performance Metrics

• C.1 Oracle HTTP Server Metrics
  • C.1.1 Oracle HTTP Server Child Server Metrics
  • C.1.2 Oracle HTTP Server Responses Metrics
  • C.1.3 Oracle HTTP Server Virtual Host Metrics
  • C.1.4 Aggregate Module Metrics
  • C.1.5 HTTP Server Module Metrics
  • C.1.6 Oracle HTTP Server mod_oc4j Metrics
  • C.1.7 Oracle HTTP Server SSL Metrics
• C.2 JVM Metrics
  • C.2.1 JVM Properties Metrics
• C.3 JDBC Metrics
  • C.3.1 JDBC Driver Metrics
  • C.3.2 JDBC Data Source Metrics
  • C.3.3 JDBC Driver Specific Connection Metrics
  • C.3.4 JDBC Data Source Specific Connection Metrics
  • C.3.5 JDBC Connection Source Metrics
  • C.3.6 JDBC Driver Statement Metrics
  • C.3.7 JDBC Data Source Statement Metrics
  • C.3.8 JDBC Connection Pool Stats Metrics
• C.4 mod_plsql Metrics
• C.5 Oracle Process Manager and Notification Server - OPMN Metrics
  • C.5.1 OPMN_PM Metric Table
  • C.5.2 OPMN_OC4J_PROC Table
  • C.5.3 OPMN_HOST_STATISTICS Metric Table
  • C.5.4 OPMN_IAS_INSTANCE Metric Table
  • C.5.5 OPMN_IAS_COMPONENT Table
  • C.5.6 OPMN ONS Metrics
  • C.5.7 OPMN_APPCTX Table
• C.6 DMS Internal Metrics

D OC4J Performance Metrics

• D.1 JTA Resource Metrics
• D.2 JCA Metrics
• D.3 OC4J J2EE Application Metrics
  • D.3.1 Web Module Metrics
  • D.3.2 Web Context Metrics
  • D.3.3 OC4J Servlet Metrics
  • D.3.4 OC4J JSP Metrics
  • D.3.5 OC4J EJB Metrics
  • D.3.6 OC4J OPMN Info Metrics
  • D.3.7 OC4J Work Management Pool Metrics
• D.4 OC4J JMS Metrics
  • D.4.1 JMS Metric Tables
  • D.4.2 JMS Stats Metric Table
  • D.4.3 JMS Request Handler Stats
  • D.4.4 JMS Connection Stats
  • D.4.5 JMS Session Stats
  • D.4.6 JMS Message Producer Stats
  • D.4.7 JMS Message Browser Stats
  • D.4.8 JMS Message Consumer Stats
  • D.4.9 JMS Durable Subscription Stats
  • D.4.10 JMS Destination Stats
  • D.4.11 JMS Temporary Destination Stats
  • D.4.12 JMS Store Stats
  • D.4.13 JMS Persistence Stats
• D.5 OC4J Task Manager Metrics
• D.6 Java Object Cache JOC Metrics

Index