It all depends. One of our databases has more that 10 GB of cache. You
platform might have some limitation. You will also need to leave
enough for PGA and enough for some non-obvious memory consumers. We
recently hit an issue on HP-UX - we were very tight on memory and one
of the instances on this box couldn't use async IO after a restart.
Apparently, there were not enough so called non-pageable memory or so
we were told. Again, if you don't have test system to test it - go
slowly carefully monitoring your system.
2006/6/19, Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>:
> 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.
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 19 2006 - 13:56:02 CDT
