Skip Headers
Oracle® Fusion Applications Performance and Tuning Guide
11
g
Release 1 (11.1.2)
Part Number E16686-01
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Monitoring and Tuning Oracle Fusion Applications
1.1
Introduction
1.1.1
Audience
1.2
Monitoring and Tuning Oracle Fusion Applications
1.2.1
How to Analyze Host Metrics
1.2.2
How to Check for Network Connectivity Issues
1.2.3
How to Analyze WebLogic Server Metrics
1.2.4
How to Analyze Oracle HTTP Server Metrics
1.2.5
How to Analyze Oracle Business Intelligence Server Metrics
1.2.6
How to Gather Key Identity Management Server Metrics
1.2.7
How to Analyze Key Enterprise Scheduler Metrics
1.2.8
How to Monitor Key SOA Metrics
1.2.9
How to Tune and Troubleshoot Oracle Identity Management
1.3
Tuning Platforms for Fusion Applications
2
Troubleshooting Process
2.1
Introduction to Troubleshooting
2.1.1
How to Troubleshoot Overall System Slowness
2.1.2
How to Find the Slowest JSPX/JSFF Pages
2.1.3
How to Troubleshoot Slow UI Request
2.1.3.1
Troubleshooting Historical Requests
2.1.3.2
Troubleshooting Live Requests
2.1.3.3
Troubleshooting StuckThreads
2.1.3.4
Troubleshooting Slow Requests Using JFR Recording
2.1.3.5
Troubleshooting Memory Leaks and Heap Usage Pressure
2.1.4
How to Troubleshoot Slow Batch Jobs
2.1.4.1
Troubleshooting Jobs That Are in Wait/Ready/Blocked State for a Long Time
2.1.4.2
Troubleshooting Jobs in Running State for a Long Time
2.1.4.3
Troubleshooting Slow BI Publisher Jobs
2.1.4.4
Troubleshooting Slow SOA Jobs
2.1.4.5
Troubleshooting Slow SQL Jobs
2.1.4.6
Troubleshooting Slow Java Jobs
2.1.5
How to Troubleshoot a Slow BPEL Instance
2.1.5.1
Troubleshooting High Connection Usage
2.1.5.2
Troubleshooting Connection Leaks
2.1.5.3
Troubleshooting Slow Requests Using SQL Trace
2.1.5.4
Troubleshooting Slow Oracle Enterprise Scheduler Jobs of SQL Type
2.1.5.5
Troubleshooting Excessive Activation
2.1.6
How to Troubleshoot Oracle Business Intelligence
2.2
View Detailed Timing Of a Request Using a JRockit Flight Recorder (JFR) File
2.3
Using My Oracle Support for Additional Troubleshooting Information
3
Tuning the Database
3.1
Introduction
3.1.1
Monitoring the Oracle Fusion Applications Database
3.2
Tuning the Database
3.2.1
How to Configure the Database for Performance
3.2.2
How to Configure Kernel Parameters
3.2.3
How to Configure the Database Listener
3.2.4
How to Tune the Real Application Cluster (RAC)
3.2.5
How to Optimize SQL Statements
3.2.5.1
Collecting Optimizer Statistics
3.2.5.2
Pinning Packages and Cursors
3.2.6
How to Configure the Database Resource Manager
3.2.6.1
Assigning Connections to Resource Consumer Groups
3.2.6.2
Using the Oracle Database Resource Manager
3.2.6.3
Monitoring the Resource Manager
Scripting on this page enhances content navigation, but does not change the content in any way.