How to measure improvements in KEEP pool?

[nir_s]

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

[davey23uk]

the only thing that matters is response time to your users

measure that

[nir_s]

Hi davey23uk,

Thanks!
I'll check it.
What about checking the amount of physical reads or the BHR of both pools?

[davey23uk]

if it didn't make any differnece to the query times, whats the point?

[nir_s]

OK, thanks!