raw data size versus bufferpool/cache size

View previous topic View next topic Go down

raw data size versus bufferpool/cache size

Post  hariza on Sun Oct 10, 2010 11:32 pm


Hi All,

I just wondering if there is a rule of thumb or a formula that tells me when it comes to sizing the memory structures like Bufferpools/Buffer cache what would be the best/ideal/recommended size. I have a 2 TB datawarehouse and I believe we are not allocating enough resources (memory) but I need to be able to support my theory with something more concrete. This is running on AIX platform. Now users are noticing a slowdown in the response time and I believe this is as a consecuence of the memory structures not being sized accordingly. Please any comments will be highly appreciated. Thanks !!!!.

Harby.

hariza

Posts : 1
Join date : 2010-10-10

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum