11g buffer cache
Any recomedations on oracle 11g DB cache on HP UX 11.31.
Can any one can suggest me some.
Here is what I would do - I'm assuming you are upgrading an existing database from Ora10g to Ora11g
- Check buffer_cache hit ratio on current Ora10g instance.
- Set Ora11g buffer_cache as Ora10g is set
- Over time check buffer_cache hit ratio on new Ora11g instance - tune as appropriate.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width