Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
parameter is used to reduce
the amount of parsing with
statements and cursors. If
your cursors are being
paged-out of the library
cache, increasing
SESSION_CACHED_CURSORS
up to the value of
OPEN_CURSORS
improves
the performance.
Apart from the preceding changes, the tablespaces for the
[ENV]_SOAINFRA
and
[ENV]_MDS
schemas should be auto-extended by around 100 MB each
time. Apply these changes to the
sp
file to persist them after database restart.
Shutdown and restart your database for these changes to take effect. Once
again, the suggested settings described in this section are guidelines and may
not be applicable to all environments.