-
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
-
Tool used
Hi
I use a tool called
Spotlight ( initailly called Insatnce Manager ) from Quest.com
-
same problem here
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|