Écrit par OCA
|
19-03-2008 |
-
stores copies of data blocks recently retrieved from the database to enable better performance when obtaining or updating data
-
is managed by a LRU algorithm
-
sized by DB_CACHE_SIZE, DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE initialization parameters
-
DB_BLOCK_SIZE determines the primary block size in the SYSTEM tablespace
-
DB_CACHE_ADVICE (OFF/ON/READY) enables/disables statistics for predicting behavior with different cache sizes
-
V$DB_CACHE_ADVICE displays these statistics
ALTER SYSTEM SET
DB_CACHE_SIZE = 96M; |
dynamically resizes the Data Buffer Cache (default 48MB on Unix / 52MB on Windows)
|
|
Dernière mise à jour : ( 15-04-2008 )
|