Database Reference
In-Depth Information
Tuned
Value
Parameter Name
Default Value
Remarks
sion that needs to modify a
block in an object. The con-
tention for ITL can be re-
duced by increasing the
INITRANS
storage paramet-
er of the table and indexes.
SHARED_POOL_SIZE
has to
be tuned to provide more
room for new cursors and
query blocks. It has to be
tuned up, if cursors are being
aged out due to lack of free
space.
SHARED_POOL_SIZE
45
300
Checksums allow Oracle to
detect corruption caused by
underlying disks, storage sys-
tems, or I/O systems. If your
application is I/O intensive
and you are short on CPU
capacity, you should disable
it.
DB_BLOCK_CHECKSUM
TYPICAL
OFF
The
SESSION_CACHED_CURSORS
SESSION_CACHED_CURSORS 50
1000
