Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
AQ_TM_PROCESSES
to
0
. If
it is set to
1
, a one time
manager process is created
to monitor the messages.
SETALL
Oracle recommends setting
this to
SETALL
to enable
both asynchronous and direct
I/O on file system files where
possible.
FILESYSTEMIO_OPTIONS
NONE
BINARY
Specifies the collating se-
quence for
ORDER BY
quer-
ies and setting to
BINARY
requires less system over-
head.
NLS_SORT
OPEN_CURSORS
specifies the
maximum number of open
cursors a session can have
at once. It is important to
have the value of
OPEN_CURSORS
set high
enough to prevent your ap-
plication from running out of
open cursors.
OPEN_CURSORS
300
1000