Database Reference
In-Depth Information
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 be-
comes 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. These
changes are part of the database initialization parameters and are made to the
init[SID].ora
file. The SQL queries can be found in the attached chapter
code.
Tuned
Value
Parameter Name
Default Value
Remarks
This property controls pro-
cessing of messages with
delay and expiration proper-
ties specified. It is strongly re-
commended not to set
AQ_TM_PROCESSES
0
1
