Re: Mysterious FILTER operation ;)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 4 Jan 2005 17:01:11 -0000
Message-ID: <034301c4f27e$fe34a2c0$6702a8c0@Primary>

One of those circumstances (I forget who first mentioned it) is if a cursor is flushed (and therefore awaiting a RELOAD, rather than a revalidation) when you close it. Oracle does not recreate the execution plan simply to be able to write it to the trace file.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated Dec 23rd 2004

Original Message ----- From: "Niall Litchfield" <niall.litchfield_at_gmail.com>

In addition, I *currently believe* that at least in recent versions of 9.2 and 10 you may not get STAT lines even if the cursor is closed by the app under certain circumstances. I do not yet know what those circumstances might be - or if I am just wrong about the underlying session closing cursors. I suspect one or more of CURSOR_SHARING=FORCE|SIMILAR and SESSION_CACHED_CURSORS; CURSOR_SPACE_FOR_TIME
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 04 2005 - 10:56:30 CST