Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions

Part I Introduction

1 Introduction and Roadmap

• 1.1 Document Scope and Audience
• 1.2 Guide to this Document
• 1.3 Related Documentation

2 Top Performance Areas

• 2.1 Identifying Top Performance Areas
• 2.2 Securing Sufficient Hardware Resources
• 2.3 Tuning the Operating System
• 2.4 Tuning Java Virtual Machines (JVMs)
• 2.5 Tuning the WebLogic Server
• 2.6 Tuning Database Parameters
  • 2.6.1 Tuning Database Parameters
  • 2.6.2 Tuning Database Files
  • 2.6.3 Tuning Automatic Segment-Space Management (ASSM)
• 2.7 Reusing Database Connections
• 2.8 Enabling Data Source Statement Caching
• 2.9 Controlling Concurrency
  • 2.9.1 Setting Server Connection Limits
    • 2.9.1.1 MaxClients/ThreadsPerChild
    • 2.9.1.2 KeepAlive
    • 2.9.1.3 Tuning HTTP Server Modules
  • 2.9.2 Configuring Connection Pools
  • 2.9.3 Tuning the WebLogic Sever Thread Pool
• 2.10 Setting Logging Levels

3 Performance Planning

• 3.1 About Oracle Fusion Middleware Performance Planning
• 3.2 Performance Planning Methodology
  • 3.2.1 Define Your Performance Objectives
    • 3.2.1.1 Define Operational Requirements
    • 3.2.1.2 Identify Performance Goals
    • 3.2.1.3 Understand User Expectations
    • 3.2.1.4 Conduct Performance Evaluations
  • 3.2.2 Design Applications for Performance and Scalability
  • 3.2.3 Monitor and Measure Your Performance Metrics

4 Monitoring Oracle Fusion Middleware

• 4.1 About Oracle Fusion Middleware Management Tools
  • 4.1.1 Measuring Your Performance Metrics
• 4.2 Oracle Enterprise Manager Fusion Middleware Control
• 4.3 Oracle WebLogic Server Administration Console
• 4.4 WebLogic Diagnostics Framework (WLDF)
• 4.5 WebLogic Scripting Tool (WLST)
• 4.6 DMS Spy Servlet
  • 4.6.1 Viewing Performance Metrics Using the Spy Servlet
  • 4.6.2 Using the DMS Spy Servlet
• 4.7 Native Operating System Performance Commands
• 4.8 Network Performance Monitoring Tools

5 Using the Oracle Dynamic Monitoring Service

• 5.1 About Dynamic Monitoring Service (DMS)
  • 5.1.1 Understanding Common DMS Terms and Concepts
    • 5.1.1.1 DMS Sensors
      • 5.1.1.1.1 DMS PhaseEvent Sensors
      • 5.1.1.1.2 DMS Event Sensors
      • 5.1.1.1.3 DMS State Sensors
      • 5.1.1.1.4 Sensor Naming Conventions
    • 5.1.1.2 DMS Nouns
      • 5.1.1.2.1 General DMS Naming
      • 5.1.1.2.2 General DMS Naming Conventions and Character Sets
      • 5.1.1.2.3 Noun and Noun Type Naming Conventions
    • 5.1.1.3 DMS Tracing and Events
• 5.2 Understanding DMS Availability
• 5.3 Understanding DMS Architecture
• 5.4 Viewing DMS Metrics
  • 5.4.1 Viewing Metrics Using the Spy Servlet
  • 5.4.2 Viewing Metrics with WLDF (WebLogic Diagnostic Framework)
  • 5.4.3 Viewing metrics with WLST (Oracle WebLogic Server)
  • 5.4.4 Viewing metrics with JConsole
  • 5.4.5 Viewing metrics with Oracle Enterprise Manager
• 5.5 Accessing DMS Metrics with WLDF
• 5.6 DMS Execution Context
  • 5.6.1 DMS Execution Requests and Sub-Tasks
  • 5.6.2 DMS Execution Context Usage
  • 5.6.3 DMS Execution Context Communication
• 5.7 DMS Tracing and Events
  • 5.7.1 Configuring the DMS Event System
    • 5.7.1.1 Adding and Editing Filters
    • 5.7.1.2 Adding and Editing Destinations
    • 5.7.1.3 Adding and Editing Event Routes
    • 5.7.1.4 Compound Operations
  • 5.7.2 Configuring Destinations
    • 5.7.2.1 LoggerDestination
      • 5.7.2.1.1 Static Loggers and Handlers
      • 5.7.2.1.2 Dynamic Loggers and Handlers
      • 5.7.2.1.3 Default Locations of the logging.xml File
      • 5.7.2.1.4 Using a CLI Command to Query the Trace Log File
    • 5.7.2.2 MBean Creator Destination
      • 5.7.2.2.1 Metric MBean Object Name
    • 5.7.2.3 Request Tracker Destination
      • 5.7.2.3.1 Executing the Request Tracker Dump
    • 5.7.2.4 Java Flight Recorder Destination
      • 5.7.2.4.1 Dynamically Derived JFR Event Types – Names, Values and Descriptions
      • 5.7.2.4.2 Examples of Dynamically Derived Producers and Events
  • 5.7.3 Understanding the Format of DMS Events in Log Messages
  • 5.7.4 Understanding DMS Event Actions
• 5.8 DMS Best Practices

Part II Core Components

6 Tuning Oracle HTTP Server

• 6.1 About Oracle HTTP Server
• 6.2 Monitoring Oracle HTTP Server Performance
• 6.3 Basic Tuning Considerations
  • 6.3.1 Tuning Oracle Server Directives
  • 6.3.2 Reducing Process Availability with Persistent Connections
  • 6.3.3 Logging Options for Oracle HTTP Server
    • 6.3.3.1 Access Logging
    • 6.3.3.2 Configuring the HostNameLookups Directive
    • 6.3.3.3 Error logging
• 6.4 Advanced Tuning Considerations
  • 6.4.1 Tuning Oracle HTTP Server
    • 6.4.1.1 Analyzing Static Versus Dynamic Requests
    • 6.4.1.2 Managing PL/SQL Requests
    • 6.4.1.3 Limiting the Number of Enabled Modules
    • 6.4.1.4 Tuning the File Descriptor Limit
  • 6.4.2 Tuning Oracle HTTP Server Security
    • 6.4.2.1 Tuning Oracle HTTP Server Secure Sockets Layer (SSL)
      • 6.4.2.1.1 Caching SSL on Oracle HTTP Server
      • 6.4.2.1.2 Using SSL Application Level Data Encryption
      • 6.4.2.1.3 Tuning SSL Performance
    • 6.4.2.2 Tuning Oracle HTTP Server Port Tunneling

7 Tuning Oracle Metadata Service

• 7.1 About Oracle Metadata Services (MDS)
• 7.2 Monitoring Oracle Metadata Service Performance
• 7.3 Basic Tuning Considerations
  • 7.3.1 Tuning Database Repository
    • 7.3.1.1 Collecting Schema Statistics
    • 7.3.1.2 Increasing Redo Log Size
    • 7.3.1.3 Reclaiming Disk Space
    • 7.3.1.4 Monitoring the Database Performance
  • 7.3.2 Tuning Cache Configuration
    • 7.3.2.1 Enabling Document Cache
  • 7.3.3 Purging Document Version History
    • 7.3.3.1 Auto Purge
    • 7.3.3.2 Manual Purge
  • 7.3.4 Using Database Polling Interval for Change Detection
• 7.4 Advanced Tuning Considerations
  • 7.4.1 Analyzing Performance Impact from Customization

8 Tuning Oracle Fusion Middleware Security Performance Tuning

• 8.1 About Security Services
• 8.2 Basic Tuning Considerations
• 8.3 Tuning Oracle Platform Security Services
  • 8.3.1 JVM Tuning Parameters
  • 8.3.2 JDK Tuning Parameters
  • 8.3.3 Authentication Tuning Parameters
  • 8.3.4 Authorization Tuning Properties
  • 8.3.5 OPSS PDP Service Tuning Parameters
• 8.4 Oracle Web Services Security Tuning
  • 8.4.1 Choosing the Right Policy
  • 8.4.2 Policy Manager
  • 8.4.3 Configuring the Log Assertion to Record SOAP Messages
  • 8.4.4 Configuring Connection Pooling
  • 8.4.5 Monitoring the Performance of Web Services

Part III Oracle Fusion Middleware Server Components

9 Tuning Oracle Application Development Framework (ADF)

• 9.1 About Oracle ADF
• 9.2 Basic Tuning Considerations
  • 9.2.1 Oracle ADF Faces Configuration and Profiling
  • 9.2.2 Performance Considerations for ADF Faces
  • 9.2.3 Tuning ADF Faces Component Attributes
  • 9.2.4 Performance Considerations for Table and Tree Components
  • 9.2.5 Performance Considerations for autoSuggest
  • 9.2.6 Data Delivery - Lazy versus Immediate
  • 9.2.7 Performance Considerations for DVT Components
• 9.3 Advanced Tuning Considerations
  • 9.3.1 ADF Server Performance
    • 9.3.1.1 Session Timeout Tuning
    • 9.3.1.2 View Objects Tuning
      • 9.3.1.2.1 Creating View Objects
      • 9.3.1.2.2 Configuring View Object Data Fetching
      • 9.3.1.2.3 Additional View Object Configurations
    • 9.3.1.3 Batch Processing
    • 9.3.1.4 RangeSize Tuning
    • 9.3.1.5 Application Module Design Considerations
    • 9.3.1.6 Application Module Pooling
      • 9.3.1.6.1 General AM Pool Configurations
      • 9.3.1.6.2 Configuring AM Pool Sizing
      • 9.3.1.6.3 AM Pool Resource Cleanup Configurations
    • 9.3.1.7 ADFc: Region Usage
    • 9.3.1.8 Defer Task Flow Execution
    • 9.3.1.9 Task Flow in a Popup
    • 9.3.1.10 Configuring the Task Flow Inside Switcher
    • 9.3.1.11 Reusing Static Data
    • 9.3.1.12 Conditional Validations

10 Tuning Oracle TopLink

• 10.1 About Oracle TopLink and EclipseLink
• 10.2 Basic Tuning Considerations
  • 10.2.1 Creating Efficient SQL Statements and Queries
    • 10.2.1.1 Tuning Entity Relationships Query Parameters
  • 10.2.2 Tuning Cache Configuration
    • 10.2.2.1 Cache Refreshing Scenarios
    • 10.2.2.2 Tuning the Locking Mode Policies
  • 10.2.3 Tuning the Mapping and Descriptor Configurations
  • 10.2.4 Using Data Partitioning
• 10.3 Advanced Tuning Considerations
  • 10.3.1 Integrating with Oracle Coherence
  • 10.3.2 Analyzing EclipseLink JPA Entity Performance

Part IV SOA Suite Components

11 Tuning the SOA Infrastructure

• 11.1 About the SOA Infrastructure
• 11.2 Tuning SOA Work Managers
  • 11.2.1 Configuring database connections with the SOADataSource property
  • 11.2.2 Configuring Work Managers with the SOAMaxThreadsConfig attribute
• 11.3 Tuning SOA Infrastructure Parameters
• 11.4 Using Advanced Tuning Options
  • 11.4.1 Enabling the Composite Lazy Loading Feature
    • 11.4.1.1 Configuring Composite Lazy Loading for the Domain level
    • 11.4.1.2 Configuring Composite Lazy Loading at the Component level
  • 11.4.2 Changing Modularity Profiles
  • 11.4.3 Tuning Your Database for SOA Processes
    • 11.4.3.1 Collecting Optimizer Statistics
      • 11.4.3.1.1 Automatic Statistics Gathering
      • 11.4.3.1.2 Manual Statistics Gathering
      • 11.4.3.1.3 Optimizing the MDS Database Repository With Statistics
    • 11.4.3.2 Tuning Temporary Tablespaces for SOA
    • 11.4.3.3 Minimizing SOA Database Contention
      • 11.4.3.3.1 log file sync
      • 11.4.3.3.2 enq:HW contention
      • 11.4.3.3.3 enq: TX - index contention
    • 11.4.3.4 Purging
    • 11.4.3.5 Reclaiming Space
  • 11.4.4 Tuning Event Delivery Network Parameters
    • 11.4.4.1 Adding JMS Topics with Mapping
  • 11.4.5 Tuning the WebLogic Server
• 11.5 Advanced Tuning for Work Managers
  • 11.5.1 Configuring Fair Share Request Class for SOA Work Managers
  • 11.5.2 Creating a New Work Manager Constraint

12 Tuning Oracle BPEL Process Manager

• 12.1 About BPEL Process Manager
• 12.2 Tuning BPEL Parameters
  • 12.2.1 Tuning BPEL Engine
    • 12.2.1.1 Tuning BPEL Engine Parameters
  • 12.2.2 Tuning BPEL in a Composite
• 12.3 Using Other Tuning Strategies
  • 12.3.1 Identifying Tables Impacted By Instance Data Growth

13 Tuning Oracle Mediator

• 13.1 About Oracle Mediator
• 13.2 Tuning Mediator Parameters
  • 13.2.1 Using Resequencer for Messages

14 Tuning Oracle Managed File Transfer

• 14.1 About Managed File Transfer
• 14.2 Tuning MFT Parameters
  • 14.2.1 Tuning Remote FTP / SFTP/ FILE Type Sources
  • 14.2.2 Minimizing MDS label
  • 14.2.3 Adjusting the Materialized Views Refresh Interval

15 Tuning Oracle Business Rules

• 15.1 About Oracle Business Rules
• 15.2 Tuning Oracle Business Rules

16 Tuning Oracle Business Process Management

• 16.1 About Oracle Business Process Management
• 16.2 Tuning Business Process Management Parameters
• 16.3 Using Other Tuning Strategies
  • 16.3.1 Tuning Oracle Workspace Applications
  • 16.3.2 Process Measurement

17 Tuning Oracle Human Workflow

• 17.1 About Oracle Human Workflow
• 17.2 Tuning Human Workflow
• 17.3 Using Other Tuning Strategies
  • 17.3.1 Improving Server Performance
  • 17.3.2 Completing Workflows Faster
  • 17.3.3 Tuning the Identity Provider
  • 17.3.4 Tuning the Database

18 Tuning Oracle Business Activity Monitoring

• 18.1 About Oracle Business Activity Monitoring
• 18.2 Tuning BAM Server Parameters
• 18.3 Other Tuning Strategies
  • 18.3.1 Creating an Index Column
  • 18.3.2 Tuning Loggers
  • 18.3.3 Tuning Continuous Query Service

19 Tuning Oracle Service Bus

• 19.1 About Oracle Service Bus
• 19.2 Tuning OSB Parameters
  • 19.2.1 Tuning Oracle Service Bus with Work Managers
  • 19.2.2 Tuning OSB Operation Settings
• 19.3 Using Other Tuning Strategies
  • 19.3.1 Tuning Resequencer in OSB
  • 19.3.2 Considering Design Time for Proxy Applications
  • 19.3.3 Tuning XQuery
  • 19.3.4 Tuning Poller-based Transports
    • 19.3.4.1 Polling Interval
    • 19.3.4.2 Read Limit

20 Tuning Oracle Enterprise Scheduler Service

• 20.1 About Enterprise Scheduler Service
• 20.2 Tuning Enterprise Scheduler Service Parameters

21 Tuning Oracle Business Intelligence Performance

• 21.1 About Oracle Business Intelligence
• 21.2 Oracle BI Server Query Performance Tuning
• 21.3 Oracle BI Server Query Cache Performance Tuning
• 21.4 Oracle BI Web Client Performance Tuning

Part V Oracle WebCenter Components

22 Tuning Oracle WebCenter Portal

• 22.1 About Oracle WebCenter Portal
• 22.2 Basic Tuning Considerations
  • 22.2.1 Setting System Limit
  • 22.2.2 Setting JDBC Data Source
  • 22.2.3 Setting JRockit Virtual Machine (JVM) Arguments
  • 22.2.4 Using Content Compression to Reduce Downloads
• 22.3 Tuning Configuration for WebCenter Portal and Portal Framework Applications
  • 22.3.1 Setting a Session Timeout for WebCenter Portal
  • 22.3.2 Setting HTTP Session Timeout for a Portal Framework Application
  • 22.3.3 Setting JSP Page Timeout
  • 22.3.4 Setting ADF Client State Token
  • 22.3.5 Setting ADF View State Compression
  • 22.3.6 Setting MDS Cache Size and Purge Rate
  • 22.3.7 Configuring Concurrency Management
• 22.4 Tuning Tools and Services Configuration
  • 22.4.1 Tuning Performance of Announcements
  • 22.4.2 Tuning Performance of Discussions
  • 22.4.3 Tuning Performance Instant Messaging and Presence
  • 22.4.4 Tuning Performance of Mail
  • 22.4.5 Tuning Performance of Personal Events
  • 22.4.6 Tuning Performance of RSS News Feeds
  • 22.4.7 Tuning Performance of Searches
  • 22.4.8 Tuning Policy Store Parameters
• 22.5 Tuning Identity Store Configuration
  • 22.5.1 Tuning the Identity Store when Using SSL
  • 22.5.2 Tuning Performance when Using OVD
  • 22.5.3 Tuning Performance when Using Active Directory
• 22.6 Tuning Portlet Configuration
  • 22.6.1 Tuning Performance of the Portlet Client
    • 22.6.1.1 Configuring Supported Locales
    • 22.6.1.2 Configuring Portlet Timeout
  • 22.6.2 Customizing the Container Runtime Environment Options
    • 22.6.2.1 Suppressing Optimistic Rendering for WSRP Portlets
    • 22.6.2.2 Setting Portlet Container Runtime Options
    • 22.6.2.3 Excluding Request Attributes for Portlets
  • 22.6.3 Tuning Performance of Oracle PDK-Java Producers
  • 22.6.4 Setting WSRP Attribute for Portlet-served Resources
  • 22.6.5 Setting WSRP Attribute for Resources Not Served by the Portlet
  • 22.6.6 Tuning Performance of OmniPortlet