Book Image

Oracle SOA Suite 11g Administrator's Handbook

By : Arun Pareek, Ahmed Aboulnaga
Book Image

Oracle SOA Suite 11g Administrator's Handbook

By: Arun Pareek, Ahmed Aboulnaga

Overview of this book

Oracle SOA Suite 11g is the backbone of messaging and application integration in a service-oriented architecture. An application administrator is responsible for an end-to-end administration and management of the infrastructure. Understanding the underlying components, services, and configuration and their relations to each other is necessary to effectively administer the Oracle SOA Suite 11g environment. Due to its sheer size, administering Oracle SOA Suite 11g is a daunting task.This book provides detailed explanations of all the core administrative and management activities around Oracle SOA Suite. It includes compact information for end-to-end administration of Oracle SOA Suite 11g. It delves into advanced topics such as silent installs, cloning, backup and recovery and high availability installations.Using this book, you will be able to administer and secure your Oracle SOA Suite services and applications. You will follow examples that you can use in your everyday life as a SOA Suite administrator. The book begins with managing composite applications, their deployments and lifecycles and then moves on to monitoring instances, service engines, Weblogic Server and composite applications. With a detailed coverage of topics like the administration of individual service components as well as configuring MBeans using both Oracle Enterprise Manager Fusion Middleware Control and WLST-based scripts, you will be equipped to work with any services and applications.Towards the end, you will be taken through identifying faults & exceptions, troubleshooting approaches, and securing various components.
Table of Contents (16 chapters)
Oracle SOA Suite 11g Administrator's Handbook
About the Authors
About the Reviewers

Tuning the dehydration store database schema

The performance of the Oracle SOA Suite 11g platform is directly dependent on the performance of the underlying dehydration store database and, hence, it becomes vitally important to tune this database for optimal performance.

Most importantly, you need to ensure that the underlying database is configured to handle adequate processes and sessions to support the infrastructure. The database must also be tuned so that it has enough memory for caching, Program Global Area (PGA), and System Global Area (SGA), and has an adequate number of open and shared cursors and processes.

The following table provides a few generic changes that you should consider making to your Oracle database to improve the response time and throughput of your SOA infrastructure. Ultimately, Oracle database tuning is a vast topic and tuning parameters are not universal, so engage your Oracle DBA during your load and performance tests to assist in providing optimal settings...