My Oracle Support Banner

Monitoring SOA Infra- Dehydration Store Performance- Single Data Source Configuration (Doc ID 1513585.1)

Last updated on FEBRUARY 01, 2015

Applies to:

Enterprise Manager for Fusion Middleware - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to provide troubleshooting steps to view  "Dehydration Store Performance" information in Cloud Control. The Dehydration Store Diagnostics feature provides a dedicated view that allows you to analyze the behavior of the SOA Dehydration database. You can monitor SQL performance metrics and table growth specifically in the context of the SOA Suite's use of the database. The view displays both throughput and wait bottleneck data which allows you to monitor the general health of the target database instance. Using Active Session History, you can track usage data and display it as a table space chart, a growth rate chart, or an execution chart. 

In order to enable Dehydration monitoring in Cloud Control, several configuration steps should be performed.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Setup of the Oracle Database hosting the SOA Dehydration Store
 Configuration collection for SOA Infra and Weblogic Server
 SOA Infra target
 Weblogic Server – JDBC Datasource
 Setup of Monitoring Configuration for SOA
 Additional checks
 How to update Connection Pool  from WebLogic Console?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.