Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
other parameter values are
deduced from this.
The default value of
SESSIONS
is derived from
PROCESSES
. If you alter the
value of
PROCESSES
, you
may want to adjust the values
of these derived parameters.
SESSIONS
150
3000
SGA
includes Shared Pool,
Database buffer cache, and
Redo Log buffer. Since
Oracle SOA Suite heavily de-
pends upon the underlying
database for continuous huge
updates and inserts, the
SGA_MAX_SIZE
should be
around 40 percent of your
physical RAM.
SGA_MAX_SIZE
5G/10G
15G
This parameter reflects the
total size of memory footprint
an SGA can consume.
SGA_MAX_SIZE
and
SGA_TARGET
5G/10G
15G
