Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Maximum Db_cache_size?

Maximum Db_cache_size?

From: Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>
Date: Mon, 19 Jun 2006 10:43:37 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B02CA293@W03856.li01r1d.lais.net>


Is it good or bad to use all available (not used for other purposes, eg. shared pool or pga) RAM for buffer cache? I am talking about 32GB RAM range.

Oracle is not in-memory database but anyway - memory access is faster than disk access.
However I understand that the way(algorithms) Oracle uses RAM may have a practical turning point when adding more RAM will only slow down things.

Therefor the question is:

Thank you in advance,
Laimis N.

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 19 2006 - 05:43:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US