More information on how to use the Buffer Cache Advisory feature can be found in Chapter 8.
Chapter 1: Getting Started with the Oracle Architecture 47
SHARED_POOL_SIZE, LARGE_POOL_SIZE, STREAMS_POOL_SIZE,
and JAVA_POOL_SIZE
The parameters SHARED_POOL_SIZE, LARGE_POOL_SIZE, STREAMS_POOL_SIZE, and JAVA_
POOL_SIZE, which size the shared pool, large pool, streams pool, and Java pool, respectively,
are automatically sized by Oracle if the SGA_TARGET initialization parameter is specified. More
information on manually tuning these areas can be found in Chapter 8.
PROCESSES
The value for the PROCESSES initialization parameter represents the total number of processes
that can simultaneously connect to the database. This includes both the background processes
and the user processes; a good starting point for the PROCESSES parameter would be 15 for the
background processes plus the number of expected maximum concurrent users; for a smaller
database, 50 is a good starting point, because there is little or no overhead associated with
making PROCESSES too big.
UNDO_MANAGEMENT and UNDO_TABLESPACE
Automatic Undo Management (AUM), introduced in Oracle9i, eliminates or at least greatly reduces
the headaches in trying to allocate the right number and size of rollback segments to handle the
undo information for transactions. Instead, a single undo tablespace is specified for all undo
operations (except for a SYSTEM rollback segment), and all undo management is handled
automatically when the UNDO_MANAGEMENT parameter is set to AUTO.
Pages:
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137