-
How to measure improvements in KEEP pool?
Hi guys,
Next week I'm going to move some segments from buffer bool DEFAULT to buffer pool KEEP , after a long investigation.
My question is how can I specificall measure the performance improvement of those segments , or on the other hand , mesure generally the performance improvement of the KEEP pool regrading this movement?
DB version - 10.2.0.4
OS - Sun Solaris 64 bit , version 5.10
Thanks in advance,
Nir
-
the only thing that matters is response time to your users
measure that
-
Hi davey23uk,
Thanks!
I'll check it.
What about checking the amount of physical reads or the BHR of both pools?
-
if it didn't make any differnece to the query times, whats the point?
-
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
|