In general, this area is used for small tables with few transactions. This cache is good for
lookup tables for such things as state codes, ZIP codes, and salesman data.
The RECYCLE cache This is a dedicated to objects you wish to flush from memory quickly.
Like the KEEP cache, the RECYCLE cache isolates objects in memory so that they do not
interfere with the normal functioning of the DEFAULT cache.
Block-size-specific caches Oracle supports multiple database block sizes within a
single database; you must create a cache for each non-default database block size.
With all the areas of the SGA??”the data block buffers, the dictionary cache, and the shared
pool??”the emphasis should be on sharing data among users. Each of these areas should be large
enough to hold the most commonly requested data from the database. In the case of the shared
pool, it should be large enough to hold the parsed versions of the most commonly used queries.
When they are adequately sized, the memory areas in the SGA can dramatically improve the
performance of individual queries and of the database as a whole.
The sizes of the KEEP and RECYCLE buffer pools do not reduce the available space in the data
block buffer cache. For a table to use one of the new buffer pools, specify the name of the buffer
pool via the buffer_pool parameter within the table??™s storage clause. For example, if you want a
table to be quickly removed from memory, assign it to the RECYCLE pool.
Pages:
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428