Hi
My shared pool is 150 M , SGA =559M and DB buffer cache =391 M
The ration of buffer cache hit =100% but the Shared Pool utilisation is only 15%.
I want to increase this to > 95% .
Woudl decreasing teh shared - Pool size improve this.
Please let me know
regards




Reply With Quote