Troubleshooting the Oracle SOA Suite 11g Infrastructure - Oracle SOA Suite 11g Administrator's Topic - page 306

Checking JVM available memory and frequency of full
garbage collection
Not enough available heap may result in excessive garbage collection, or de-
pending on the garbage collection algorithm being used, increased pause times
may occur which could also result in higher CPU utilization. Revisit Chapter 4 ,
Tuning Oracle SOA Suite 11g for Optimum Performance for information on mon-
itoring and running the JVM. Note that JRockit and Sun JDK have different tun-
ing approaches and we recommend reviewing the Oracle Fusion Middleware
Performance and Tuning for Oracle WebLogic Server 11g Release 1 document-
ation for details regarding additional JVM tuning.
Checking connection pools
When connection pools are exhausted, this may lead to transactional failures.
The errors though are quite obvious in both the logs and in the Flow Trace of the
composite instances. Connections pools may be subject to constant dimension-
ing depending upon the throughput and interaction with the database.
Checking database performance
Often under heavy load, a larger number of writes to the database may have
a direct impact on I/O on the database server. Tools such as Oracle Enterprise
Manager Database Control or Oracle Enterprise Manager Grid Control can give
you an insight into the performance of your database. Other times, data growth
can also contribute to slow console performance. Oracle Database tuning is a
huge topic in itself, but we provided a few recommendations in Chapter 4 , Tun-
ing Oracle SOA Suite 11g for Optimum Performance . Run a few queries to de-
termine if your database has adequate free space to process instance requests,
such as the following:
SELECT A.TABLESPACE_NAME TABLESPACE, B.AUTOEXTENSIBLE, B.INCREMENT_BY, SUM (A.BYTES)/1024/1024 FREE_SPACE_MB, SUM (A.BLOCKS) FREE_BLOCKS, SUM (B.BYTES)/1024/1024 ALLOCATED_SPACE_MB FROM SYS.DBA_FREE_SPACE A SYS.DBA_DATA_FILES B WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME ='DEV_SOAINFRA' GROUP BY A.TABLESPACE_NAME, B.AUTOEXTENSIBLE, B.INCREMENT_BY;
The output of this query is shown in the following screenshot. It shows that
the AUTOEXTENSIBLE column of SOAINFRA data space is TRUE (good!), the