1/37
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 Redo Logs Location and Sizing
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
Part II Core Components
5
Understanding 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 Tracing and Events
5.1.1.2
DMS Nouns
5.1.1.3
DMS Sensors
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.4.6
Viewing metrics using WSADMIN (IBM WebSphere)
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.2
MBean Creator Destination
5.7.2.3
HTTP Request Tracker Destination
5.7.2.4
JRockit Flight Recorder Destination
5.7.3
Understanding DMS Event Output
5.7.4
Understanding DMS Event Actions
5.8
DMS Best Practices
6
Oracle HTTP Server Performance Tuning
6.1
About Oracle HTTP Server
6.2
Monitoring Oracle HTTP Server Performance
6.3
Basic Tuning Considerations
6.3.1
Tuning Oracle HTTP Server Directives
6.3.2
Reducing Httpd 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.2
Tuning Oracle HTTP Server Port Tunneling
7
Oracle Metadata Service (MDS) Performance Tuning
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
Part III Oracle Fusion Middleware Server Components
8
Oracle Application Development Framework Performance Tuning
8.1
About Oracle ADF
8.2
Basic Tuning Considerations
8.2.1
Oracle ADF Faces Configuration and Profiling
8.2.2
Performance Considerations for ADF Faces
8.2.3
Tuning ADF Faces Component Attributes
8.2.4
Performance Considerations for Table and Tree Components
8.2.5
Performance Considerations for autoSuggest
8.2.6
Data Delivery - Lazy versus Immediate
8.2.7
Performance Considerations for DVT Components
8.3
Advanced Tuning Considerations
8.3.1
ADF Server Performance
8.3.1.1
HTTP Session Timeout Tuning
8.3.1.2
View Objects Tuning
8.3.1.3
Batch Processing
8.3.1.4
RangeSize Tuning
8.3.1.5
Application Module Design Considerations
8.3.1.6
Application Module Pooling
8.3.1.7
ADFc: Region Usage
8.3.1.8
Defer Task Flow Execution
8.3.1.9
Task Flow in a Popup
8.3.1.10
Configuring the Task Flow Inside Switcher
8.3.1.11
Reusing Static Data
8.3.1.12
Conditional Validations
9
Oracle TopLink (EclipseLink) JPA Performance Tuning
9.1
About Oracle TopLink and EclipseLink
9.2
Basic Tuning Considerations
9.2.1
Creating Efficient SQL Statements and Queries
9.2.1.1
Tuning Entity Relationships Query Parameters
9.2.2
Tuning Cache Configuration
9.2.2.1
Cache Refreshing Scenarios
9.2.2.2
Tuning the Locking Mode Policies
9.2.3
Tuning the Mapping and Descriptor Configurations
9.2.4
Using Data Partitioning
9.3
Advanced Tuning Considerations
9.3.1
Integrating with Oracle Coherence
9.3.2
Analyzing EclipseLink JPA Entity Performance
10
Oracle Web Cache Performance Tuning
10.1
About Oracle Web Cache
10.2
Performance Considerations
10.2.1
Optimizing Hardware Resources
10.2.1.1
Hardware Resources
10.2.1.2
Memory Configuration
10.2.2
Optimizing Platform Connections
10.2.2.1
UNIX Connections
10.2.2.2
Windows Connections
10.3
Basic Tuning Considerations
10.3.1
Optimizing Network Connections
10.3.1.1
Network Bandwidth
10.3.1.2
Network Connections
10.3.1.3
Network-Related Parameters
10.3.2
Increasing Cache Hit Rates
10.3.3
Optimizing Response Time
10.4
Advanced Tuning Considerations
10.4.1
Optimizing Performance with Oracle ADF
Part IV SOA Suite Components
11
General Tuning for SOA Suite Components
11.1
About SOA Suite Configuration Properties
11.2
SOA Infrastructure Configurations
11.2.1
Audit Level
11.2.2
Capture Composite Instance State
11.2.3
Instance Tracking Audit Trail Threshold
11.2.4
Logging Level
11.3
Modifying SOA Configuration Parameters
11.4
JVM Tuning Parameters
11.5
Database Settings
11.5.1
Configuring Data Sources for SOA
11.5.2
Managing Tables and Indexes
11.5.3
Weblogic Server Performance Tuning
12
Oracle Business Rules Performance Tuning
12.1
About Oracle Business Rules
12.2
Basic Tuning Considerations
12.2.1
Use Java Beans
12.2.2
Assert Child Facts instead of Multiple Dereferences
12.2.3
Avoid Side Affects in Rule Conditions
12.2.4
Avoid Expensive Operations in Rule Conditions
12.2.5
Consider Pattern Ordering
12.2.6
Consider the Ordering of Tests in Rule Conditions
12.2.7
Enable assertXPath Support
13
Oracle BPEL Process Manager Performance Tuning
13.1
About BPEL Process Manager
13.2
Basic Tuning Considerations
13.2.1
BPEL Threading Model
13.2.1.1
Dispatcher System Threads
13.2.1.2
Dispatcher Invoke Threads
13.2.1.3
Dispatcher Engine Threads
13.2.1.4
Dispatcher Maximum Request Depth
13.2.2
Tuning Audit Levels
13.2.2.1
Audit Level
13.2.2.2
Audit Trail Threshold
13.2.2.3
Audit Store Policy
13.2.2.4
Audit Flush ByteThreshold
13.2.2.5
Audit Flush EventThreshold
13.2.3
Tuning Database Persistence for BPEL
13.2.4
Tuning Invoke Messages
13.2.5
Tuning Processed Requests List
13.2.6
Tuning XML Document Persistence
13.2.7
Validating XML
13.2.8
Tuning Wait Time
13.2.9
Tuning Instance Key Block Size
13.2.10
Tuning Automatic Recovery Attempts
13.3
Advanced Tuning Considerations
13.3.1
Tuning BPEL Properties Set Inside a Composite
13.3.2
Identifying Tables Impacted By Instance Data Growth
14
Oracle Business Activity Monitoring Performance Tuning
14.1
About Oracle Business Activity Monitoring
14.2
Basic Tuning Considerations
14.2.1
BAM Server Tuning
14.2.1.1
Set the ViewSetSharing and ElementCountLimit Parameters
14.2.1.2
Enable the Async Servlet
14.2.2
BAM Dashboard Tuning
14.2.2.1
Tune the Active Data Retrieval Interval
14.2.3
BAM Database Tuning
14.2.4
Internet Browser Tuning
14.2.4.1
Set iActiveDataScriptsCleanupFactor
14.2.4.2
Set Browser Cache Settings
14.2.5
Enterprise Message Source Tuning
14.2.5.1
Message Batching
15
Oracle Mediator Performance Tuning
15.1
About Oracle Mediator
15.2
Basic Tuning Considerations
15.2.1
Tuning metricsLevel
15.2.2
Using Domain-Value Maps
15.2.3
Deploying Deferred Routing Rules
15.2.4
Tuning Error and Retry Parameters
15.2.5
Setting the Audit Level
15.2.6
Using Resequencer for Messages
15.3
Tuning Event Delivery Network (EDN)
16
Oracle Business Process Management Performance Tuning
16.1
About Oracle Business Process Management
16.2
Basic Tuning Considerations
16.2.1
Audit Level
16.2.2
LargeDocumentThreshold
16.2.3
Dispatcher System Threads
16.2.4
Dispatcher Engine Threads
16.2.5
Dispatcher Invoke Threads
16.3
Tuning Oracle Workspace and Worklist Applications
16.4
Tuning Process Analytics
16.4.1
Process Measurement
16.4.2
Tuning Process Cubes
17
Oracle Human Workflow Performance Tuning
17.1
About Oracle Human Workflow
17.2
Basic Tuning Considerations
17.2.1
Minimize Client Response Time
17.2.2
Choose the Right Workflow Service Client
17.2.3
Narrow Qualifying Tasks Using Precise Filters
17.2.4
Retrieve Subset of Qualifying Tasks (Paging)
17.2.5
Fetch Only the Information That Is Needed for a Qualifying Task
17.2.6
Reduce the Number of Return Query Columns
17.2.7
Use the Aggregate API for Charting Task Statistics
17.2.8
Use the Count API Methods for Counting the Number of Tasks
17.2.9
Create Indexes On Demand for Flexfields
17.2.10
Use the doesTaskExist Method
17.3
Improving Server Performance
17.3.1
Archive Completed Instances Periodically
17.3.2
Select the Appropriate Workflow Callback Functionality
17.3.3
Minimize Performance Impacts from Notification
17.3.4
Deploy Clustered Nodes
17.4
Completing Workflows Faster
17.4.1
Use Workflow Reports to Monitor Progress
17.4.2
Specify Escalation Rules
17.4.3
Specify User and Group Rules for Automated Assignment
17.4.4
Use Task Views to Prioritize Work
17.5
Tuning Identity Provider
17.6
Tuning the Database
18
Oracle Adapters Performance Tuning
18.1
About Oracle Adapters
18.2
Oracle JCA Adapters for Files/FTP
18.2.1
Inbound Throttling Best Practices
18.2.2
Outbound Throttling Best Practices
18.2.3
Outbound Performance Best Practices
18.3
Oracle JCA Adapter for Database Tuning
18.3.1
JCA Adapter Basic Tuning Considerations
18.3.2
Existence Checking
18.3.3
Throttling
18.3.3.1
Formula
18.3.3.2
RowsPerPollingInterval and MaxTransactionSize
18.3.3.3
Configuration
18.4
Oracle Socket Adapter Tuning
18.5
Oracle SOA JMS Adapter Tuning
18.5.1
adapter.jms.receive.threads Property
18.6
Oracle AQ Adapter Tuning
18.6.1
adapter.aq.dequeue.threads Property
18.7
Oracle MQ Adapter Tuning
19
User Messaging Service Performance Tuning
19.1
About Oracle User Messaging Services
19.2
Basic Tuning Considerations
19.2.1
SMPP Driver Performance Tuning
19.2.2
Email Driver Polling Frequency
19.3
Database Tuning for Optimal Throughput
20
Oracle B2B Performance Tuning
20.1
About Oracle B2B
20.2
Basic Tuning Considerations
20.2.1
Tuning Data Storage Configurations for B2B
20.2.2
Tuning MDS Cache Size
20.2.3
Tuning Number of Threads
20.2.4
Tuning the JMS Multiple Out Queues Setting
21
Oracle Service Bus Performance Tuning
21.1
About Oracle Service Bus
21.2
Monitoring Oracle Service Bus
21.3
Basic Tuning Considerations
21.3.1
Tuning JVM Memory
21.3.2
Tuning WebLogic Server for OSB
21.3.2.1
Domain Mode
21.3.2.2
WebLogic Server Logging Levels
21.3.2.3
HTTP Access Logging
21.3.2.4
JMS Tuning
21.3.2.5
Connection Backlog Buffering
21.3.3
Tuning OSB Operational Settings
21.3.3.1
OSB Tracing
21.3.3.2
Cache Tuning for Proxy Service Run-Time Data
21.4
Advanced Tuning Considerations
21.4.1
Transport Tuning (Oracle WebLogic Server and Oracle Service Bus)
21.4.1.1
Polling Interval
21.4.1.2
Read Limit
21.4.2
Design Time Considerations for Proxy Applications
21.4.3
Design Considerations for XQuery Tuning
22
Oracle Business Intelligence Performance Tuning
22.1
About Oracle Business Intelligence
22.2
Oracle BI Server Query Performance Tuning
22.3
Oracle BI Server Query Cache Performance Tuning
22.4
Oracle BI Web Client Performance Tuning
Part V Identity Management Suite Components
23
Oracle Internet Directory Performance Tuning
23.1
About Oracle Internet Directory
23.2
Monitoring Oracle Internet Directory Performance
23.2.1
Monitoring Performance on UNIX and Windows Systems
23.2.2
Obtaining Recommendations by Using the Tuning and Sizing Wizard
23.2.3
Updating Database Statistics by Using oidstats.sql
23.2.4
Setting Performance-Related Replication Configuration Attributes
23.2.5
Managing System Configuration Attributes
23.2.6
Setting Garbage Collection Configuration Attributes
23.2.6.1
Modifying Changelog Purging Attributes by Using ldapmodify
23.2.6.2
Modifying Changelog Purging in Oracle Directory Services Manager
23.3
Basic Tuning Considerations
23.3.1
Database Parameters
23.3.2
LDAP Server Attributes
23.3.3
Database Statistics
23.3.4
Low-Priority Tuning Considerations
23.3.4.1
Controlling the Number of Entries to be Returned by a Search
23.3.4.2
Enabling the Group Cache
23.3.4.3
Timeout for Write Operations
23.4
Advanced Tuning Considerations
23.4.1
Replication or Oracle Directory Integration Platform
23.4.2
Replication Server Configuration
23.4.3
Garbage Collection Configuration
23.4.4
Oracle Internet Directory with Cluster Configuration
23.4.5
Password Policies and Verifier Profiles
23.4.6
Server Entry Cache
23.4.6.1
Benefits of Using the Entry Cache
23.4.6.2
Values for Configuring the Entry Cache
23.4.7
Result Set Cache
23.4.7.1
When to Use Result Set Cache
23.4.7.2
Benefits of Using Result Set Cache
23.4.7.3
Configuring Result Set Cache
23.4.8
Tuning Security Event Tracking
23.4.9
Optimizing Searches
23.4.9.1
Optimizing Searches for Large Group Entries
23.4.9.2
Optimizing Searches for Skewed Attributes
23.4.9.3
Optimizing Performance of Complex Search Filters
23.5
Specific Use Cases That Require Additional Tuning
23.5.1
Bulk Load Operations
23.5.2
Bulk Delete Operations
23.5.3
High LDAP Write Operations Load
23.5.4
Sparc T4 Hardware Tuning
24
Oracle Unified Directory Performance Tuning
24.1
About Oracle Unified Directory
24.2
Performance Considerations
24.3
Monitoring Unified Directory Performance
24.3.1
Examining Log Files
24.3.2
Monitoring the Server With LDAP
24.3.3
Monitoring the Server With SNMP
24.4
Basic Tuning Considerations
24.4.1
Tuning Java Virtual Machine Settings
24.4.2
Tuning the Server Configuration
24.4.2.1
Oracle Berkeley DB Java Edition Tuning Parameters
24.4.2.2
Core Server Tuning Parameters
24.5
Advanced Tuning Recommendations
25
Oracle Virtual Directory Performance Tuning
25.1
About Oracle Virtual Directory
25.2
Basic Tuning Considerations
25.2.1
Tuning the Ping Interval
25.2.2
Tuning Worker Threads
25.2.3
Tuning Work Queue Capacity
25.2.4
Tuning the LDAP Connection Pool
25.2.5
Tuning Heap Size
25.3
Advanced Tuning Considerations
25.3.1
Tuning Database Adapters
25.3.2
Tuning Join Adapters
25.3.3
Tuning Filters
25.3.4
Tuning Load Balancer Local Store Adapter
25.3.5
Tuning the Cache Plug-In
25.3.5.1
Cache Hit Logic
25.3.5.2
Cache Plug-in Memory Management
25.3.6
Tuning LDAP Listener
25.3.7
Tuning the Server for OVD
26
Oracle Identity Federation Performance Tuning
26.1
About Oracle Identity Federation
26.2
Basic Tuning Considerations
26.2.1
Tuning Database Parameters for Identity Federation
26.2.1.1
Data Sources
26.2.1.2
RDBMS Session Cache
26.2.1.3
RDBMS Compression
26.2.2
Tuning the Oracle HTTP Server
26.3
Advanced Tuning Considerations
26.3.1
Tuning the LDAP Servers
26.3.1.1
Connection Pool Settings
26.3.1.2
Connection Settings
26.3.1.3
Federation Data Store Settings
26.3.2
Tuning SAML Protocol
26.3.2.1
SOAP Connections
26.3.2.2
XML Digital Signatures
26.3.2.3
POST and Artifact Single Sign-On Profiles
27
Oracle Fusion Middleware Security Performance Tuning
27.1
About Security Services
27.2
Basic Tuning Considerations
27.3
Tuning Oracle Platform Security Services
27.3.1
JVM Tuning Parameters
27.3.2
JDK Tuning Parameters
27.3.3
LDAP Tuning Parameters
27.3.4
Authentication Tuning Parameters
27.3.5
Authorization Tuning Properties
27.3.6
OPSS PDP Service Tuning Parameters
27.4
Oracle Web Services Security Tuning
27.4.1
Choosing the Right Policy
27.4.2
Policy Manager
27.4.3
Configuring the Log Assertion to Record SOAP Messages
27.4.4
Configuring Connection Pooling
27.4.5
Monitoring the Performance of Web Services
Part VI Oracle WebCenter Portal Components
28
Oracle WebCenter Portal Performance Tuning
28.1
About Oracle WebCenter Portal
28.2
Basic Tuning Considerations
28.2.1
Setting System Limit
28.2.2
Setting JDBC Data Source
28.2.3
Setting JRockit Virtual Machine (JVM) Arguments
28.2.4
Using Content Compression to Reduce Downloads
28.3
Tuning Configuration for WebCenter Portal and Portal Framework Applications
28.3.1
Setting a Session Timeout for WebCenter Portal
28.3.2
Setting HTTP Session Timeout for a Portal Framework Application
28.3.3
Setting JSP Page Timeout
28.3.4
Setting ADF Client State Token
28.3.5
Setting ADF View State Compression
28.3.6
Setting MDS Cache Size and Purge Rate
28.3.7
Configuring Concurrency Management
28.4
Tuning Tools and Services Configuration
28.4.1
Tuning Performance of Announcements
28.4.2
Tuning Performance of Discussions
28.4.3
Tuning Performance Instant Messaging and Presence
28.4.4
Tuning Performance of Mail
28.4.5
Tuning Performance of Personal Events
28.4.6
Tuning Performance of RSS News Feeds
28.4.7
Tuning Performance of Searches
28.4.8
Tuning Policy Store Parameters
28.5
Tuning Identity Store Configuration
28.5.1
Tuning the Identity Store when Using SSL
28.5.2
Tuning Performance when Using OVD
28.5.3
Tuning Performance when Using Active Directory
28.6
Tuning Portlet Configuration
28.6.1
Tuning Performance of the Portlet Client
28.6.1.1
Configuring Supported Locales
28.6.1.2
Configuring Portlet Cache Size
28.6.1.3
Configuring Portlet Timeout
28.6.2
Enabling Java Object Cache for WSRP Producers
28.6.3
Customizing the Container Runtime Environment Options
28.6.3.1
Suppressing Optimistic Rendering for WSRP Portlets
28.6.3.2
Setting Portlet Container Runtime Options
28.6.3.3
Excluding Request Attributes for Portlets
28.6.4
Tuning Performance of Oracle PDK-Java Producers
28.6.5
Setting WSRP Attribute for Portlet-served Resources
28.6.6
Setting WSRP Attribute for Resources Not Served by the Portlet
28.6.7
Tuning Performance of OmniPortlet
Scripting on this page enhances content navigation, but does not change the content in any way.