Re: Mysterious FILTER operation ;)
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Jan 2005 17:01:11 -0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
