Shared Pool Size

Shared Pool Size

 

  

Hi Guys,

I have one question..

Are there any performance degradation issues if shared pool is set to a high value. I change from 640MB to 1024 MB and looks like buffer hit ratios is coming down.
What is the best way to tune it? I know it could be hard to explain it in the e-mail. But you can send me any important part of it.

Thanks for your help.

Raj



---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
Oracle LazyDBA home page