RE: buffer cache > 2GB and sga_max_size > 4GB possible problems?

Sonja,

Go to www.oracledba.co.uk. Click 'Tuning' in the menu bar, and then 'Custom Hit Ratio'.

It will deliver you any hit ratio you want, as long as it is higher than your current hit ratio.

BTW, performance of your system will stay appr. the same, it doesn't do too much harm to it generally.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> Well, we have buffer waits and also async I/O activated.
> Can you tell me where I can get the script you mentioned?
>
> TIA,
> Sonja
>

--
http://www.freelists.org/webpage/oracle-l