Database Reference
In-Depth Information
Init.Ora
Most of the database initialization parameters are stored in the
Init.ora
file for
Oracle database 11
g
. Some of the important configuration parameters related to
SOA Suite container performance are as follows:
•
Memory_Target
: Manage the RAM resource utilization. Instead of set-
ting
SGA_MAX_Size
, use
SGA
and
PGA
as needed.
•
Audit_Trial
: Database auditing can be enabled or disabled using this
parameter.
• Always enable auto extend of Oracle Tablespace to avoid performance
and run time issues. Use
Automatic Segment Space Management
(
ASSM
) for permanent table spaces.
Automatic Workload Repository
You can use
Automatic Workload Repository
(
AWR
) for tuning the SOA_INFRA
database. AWR is a part of the Oracle database. The Oracle database automatically
collects performance information such as snap shots on periodic bases (every
hour).The Oracle database takes care of cleaning the snap shot performance data
on a regular basis.
As shown in the following screenshot, please login to the Oracle database to run the
report: