Shared Pool in use Ratio

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

Could you describe how you determined the percentage for shared pool utilization?

yes certinly, but be aware of that your process size also increases propotionally.

Sam

Hi

I use a tool called
Spotlight ( initailly called Insatnce Manager ) from Quest.com

I also use spotlight, and have the same question about one of my db's. (its my test box where I am testing 8.1.7, so its not too critical at the moment).

My other question is, would this problem effect the speed that it takes to create and Intermedia text index. I have an index that i am trying to create that has been loading since mid day yesterday!! Any thoughts would be appreciated. (I know that it will create, because I have created the index on a smaller table without many problems)

Thanks!
-Ray