Re: "'Resultcache" effect in 10.2.0.4 ??
From: jlchiappa <jlchiappa_at_gmail.com>
Date: Fri, 24 Jul 2009 09:37:02 -0700 (PDT)
Message-ID: <da5d90b0-1c83-46fa-837d-fa328a0709f6_at_s6g2000vbp.googlegroups.com>
Ops, sorry, gd spoke about dynamic sampling, so the answers are misplaced : the anwer about the same behavior even if the same SQL with same value is executed (eliminating the chance for BVP, I think) is to joe, to gd is the answer about stats in-place negating the chance for DS.
Date: Fri, 24 Jul 2009 09:37:02 -0700 (PDT)
Message-ID: <da5d90b0-1c83-46fa-837d-fa328a0709f6_at_s6g2000vbp.googlegroups.com>
Ops, sorry, gd spoke about dynamic sampling, so the answers are misplaced : the anwer about the same behavior even if the same SQL with same value is executed (eliminating the chance for BVP, I think) is to joe, to gd is the answer about stats in-place negating the chance for DS.
Regards,
Chiappa Received on Fri Jul 24 2009 - 11:37:02 CDT