Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> bind variable peeking and regular statistics gathering

bind variable peeking and regular statistics gathering

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 31 May 2007 17:32:29 +0700
Message-ID: <3edcb66e0705310332o71793c69of6b551271140eddd@mail.gmail.com>


all,

i'm not sure about the relation between bind variable peeking and invalidation in the regard of regularly gathering statistics.

will the bind variable peeking will re-peek when invalidation occurs after gathering statistics?

--

regards
ujang
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 31 2007 - 05:32:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US