Book Image

Oracle SOA Suite 11g Performance Tuning Cookbook

Book Image

Oracle SOA Suite 11g Performance Tuning Cookbook

Overview of this book

Oracle SOA Suite 11g forms the heart of many organisations' Service Oriented Architecture. Yet for such a core component, simple information on how to tune and configure SOA Suite and its infrastructure is hard to find. Because Oracle SOA Suite 11g builds on top of a variety of infrastructure components, up until now there has been no one single complete reference that brings together all the best practices for tuning the whole SOA stack. Oracle SOA Suite 11g Performance Tuning Cookbook contains plenty of tips and tricks to help you get the best performance from your SOA Suite infrastructure. From monitoring your environment so you know where bottlenecks are, to tuning the Java Virtual Machine, WebLogic Application Server, and BPEL and BPMN mediator engines, this book will give you the techniques you need in a easy to follow step-by-step guide. Starting with how to identify problems, and building on that with sections on monitoring, testing, and tuning, the recipes in this book will take you through many of the options available for performance tuning your application. There are many considerations to make when trying to get the best performance out of the Oracle SOA Suite platform. This performance Cookbook will teach you the whole process of tuning JVM garbage collection and memory, tuning BPEL and BPMN persistence settings, and tuning the application server. This book focuses on bringing together tips on how to identify the key bottlenecks in the whole SOA Suite infrastructure, and how to alleviate them. The Oracle SOA Suite 11g Performance Tuning Cookbook will ensure that you have the tools and techniques to get the most out of your infrastructure, delivering reliable, fast, and scalable services to your enterprise.
Table of Contents (19 chapters)
Oracle SOA Suite Performance Tuning Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Purging data from the BPEL store


In this recipe we will remove old BPEL dehydration data and state from the SOA infrastructure database.

Getting ready

You will need to have access to the database on which the SOA_INFRA schema is hosted. In this recipe, we'll be using a command line local to the host on which we installed the database.

You'll also need access to the SQL scripts bundled with SOA Suite. If you have SOA Suite installed on the host running the database, you can find them under MW_HOME/SOA_ORACLE_HOME/rcu/integration/soainfra/sql/soa_purge.

If the database is running on a separate host, you can simply copy the soa_purge directory from the WebLogic administration server to a directory on the database host; we'll be using e:\soa_purge for this purpose.

How to do it...

Follow these steps to run the soa_purge scripts:

  1. First, log in to sqlplus as a user with sysdba privileges, and grant the following permissions to the dev_soainfra user, then exit the shell:

    sqlplus / as sysdba
    SQL> GRANT...