How to measure improvements in KEEP pool?
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,
the only thing that matters is response time to your users
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?
Click Here to Expand Forum to Full Width