Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in This Guide

• New and Changed Features for 11g Release 5 (11.1.5)

1 Monitoring and Tuning Oracle Fusion Applications

• 1.1 Introduction
• 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 Oracle Fusion Applications
• 1.4 Tuning Oracle HTTP Server

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
  • 3.2.7 How to Tune the PS_TXN Table in the FUSION Schema