Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
SGA_TARGET
should be
tuned to the same value.
PGA_AGGREGATE_TARGET
1G
5G
PGA_AGGREGATE_TARGET
specifies the total amount of
session PGA memory that
Oracle will attempt to allocate
across all sessions. Tune it to
around 30 percent of your
SGA.
SIMILAR
Oracle uses a shared SQL
area when applications send
similar SQL statements to the
database. The sharing of
SQL by setting
CURSOR_SHARING
to
SIMILAR
reduces memory
use on the database server,
thereby increasing system
throughput.
CURSOR_SHARING
EXACT
INITRANS
(for table)
The
INITRANS
setting con-
trols
Initial Transaction
Slots (ITLs)
. A transaction
slot is required for any ses-
1
20
INITRANS
(for indexes)
2
40