Re: Mysterious FILTER operation ;)

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@xxxxxxxxx>

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

Other related posts: