Re: "'Resultcache" effect in 10.2.0.4 ??
From: jlchiappa <jlchiappa_at_gmail.com>
Date: Fri, 24 Jul 2009 09:31:12 -0700 (PDT)
Message-ID: <9ed61a31-f5d4-4fbc-a773-cfa63529bd0b_at_k26g2000vbp.googlegroups.com>
_at_joel : no , sorry, I forget to say, but the stats are up to date and
collected in full, so (imho) this would not occur..
_at_jg, even with we execute the same SQL with the same values the first
execution is "slow" and the sub-sequent execution is fast, so no, bvp could explain the case with diferent values but not this.
Date: Fri, 24 Jul 2009 09:31:12 -0700 (PDT)
Message-ID: <9ed61a31-f5d4-4fbc-a773-cfa63529bd0b_at_k26g2000vbp.googlegroups.com>
_at_joel : no , sorry, I forget to say, but the stats are up to date and
collected in full, so (imho) this would not occur..
_at_jg, even with we execute the same SQL with the same values the first
execution is "slow" and the sub-sequent execution is fast, so no, bvp could explain the case with diferent values but not this.
Regards,
Chiappa Received on Fri Jul 24 2009 - 11:31:12 CDT