Books for you

The majority of tuning efforts focused on the database buffer cache and the shared
pool.
Automatic sizing for the SGA
Oracle Database 10g eliminated manual tuning of SGA pools with automatic sizing
for the SGA. Using automatic shared memory management, the database automatically
allocates memory for the following SGA pools: database buffer cache, shared
pool, large pool, Java pool, and Streams pool. Youhave to specify only the total
amount of memory required by setting the SGA_TARGET initialization parameter.
Oracle and Memory Resources | 177
Since Oracle Database 10g, the database proactively monitors the memory requirements
for each pool and dynamically reallocates memory when appropriate. Youcan
also specify the minimum amount of memory for any of the SGA pools while using
automatic SGA sizing using the following initialization parameters: DB_CACHE_
SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, JAVA_POOL_SIZE, and
STREAMS_POOL_SIZE. A few SGA pools, specified using such parameters as
LOG_BUFFER, DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE, are
still manually sized.


Pages:
370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394