DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Shared Pool in use Ratio

  1. #1
    Join Date
    Nov 1999
    Posts
    226

    Unhappy

    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

  2. #2
    Join Date
    Oct 2000
    Posts
    10
    Could you describe how you determined the percentage for shared pool utilization?

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    yes certinly, but be aware of that your process size also increases propotionally.

    Sam

  4. #4
    Join Date
    Nov 1999
    Posts
    226

    Tool used

    Hi

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

  5. #5
    Join Date
    Feb 2000
    Location
    Long Beach, CA, USA
    Posts
    3

    Angry 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
  •  


Click Here to Expand Forum to Full Width