Menu Content/Inhalt

Identification






Mot de passe oublié ?
Database Buffer Cache Convertir en PDF Version imprimable Suggérer par mail
É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)  
DBC.jpg
 
Dernière mise à jour : ( 15-04-2008 )
 
< Précédent   Suivant >