RE: Do any of you know?

From: <Christopher.Taylor2_at_parallon.net>
Date: Fri, 12 Oct 2012 10:05:40 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8856253287D_at_NADCWPMSGCMS10.hca.corpad.net>

Correct. I know that.

I use dbms_pool.purge to flush the plan information. I wasn't clear on that I guess.

Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MacGregor, Ian A. Sent: Friday, October 12, 2012 9:59 AM
To: oracle-l_at_freelists.org
Subject: RE: Do any of you know?

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-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 12 2012 - 17:05:40 CEST