Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
INTERPRETED NATIVE
PL/SQL compilation mode of
NATIVE
is typically faster
than
INTERPRETED
.
PLSQL_CODE_TYPE
Setting this to
FALSE
may
result in minimal performance
improvement, but you may
lose valuable diagnostic in-
formation in the event of a
database error.
TRACE_ENABLED
TRUE
FALSE
By setting
UNDO_RETENTION
to
0
, you
enable auto tuned retention.
That is, as long as your ta-
blespace can autoextend,
you are less likely to get an
ORA-01555
.
UNDO_RETENTION
900
0
Sets the maximum number of
processes that can be started
by an instance. This is one of
the more important primary
parameters to set and tuned
to a higher value, as many
PROCESSES
150
3000