RE: Do any of you know?
From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Fri, 12 Oct 2012 07:58:55 -0700
Message-ID: <FD1D618E4F164D4C8BA5513D4268174A01A19761C075_at_EXCHCLUSTER1-02.win.slac.stanford.edu>
Taking system stats does not invalidate cursors. Statements will continue to use the same plans until they are re-parsed for other reasons,
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net [Christopher.Taylor2_at_parallon.net] Sent: Friday, October 12, 2012 7:43 AM
To: jonathan_at_jlcomp.demon.co.uk; mwf_at_rsiz.com; niall.litchfield_at_gmail.com; oratune_at_yahoo.com; breitliw_at_centrexcc.com Cc: oracle-l_at_freelists.org
Subject: Do any of you know?
Date: Fri, 12 Oct 2012 07:58:55 -0700
Message-ID: <FD1D618E4F164D4C8BA5513D4268174A01A19761C075_at_EXCHCLUSTER1-02.win.slac.stanford.edu>
Taking system stats does not invalidate cursors. Statements will continue to use the same plans until they are re-parsed for other reasons,
Ian A. MacGregor
SLAC National Accelerator Laboratory
Computing Division
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net [Christopher.Taylor2_at_parallon.net] Sent: Friday, October 12, 2012 7:43 AM
To: jonathan_at_jlcomp.demon.co.uk; mwf_at_rsiz.com; niall.litchfield_at_gmail.com; oratune_at_yahoo.com; breitliw_at_centrexcc.com Cc: oracle-l_at_freelists.org
Subject: Do any of you know?
When gathering SYSTEM stats, do those stats take a while to affect the query plans once they are collected? (a "while" being some "x" amount of time - I thought they would be immediate)
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 12 2012 - 16:58:55 CEST