Re: Stored outline problems

It is possible that the note is unpublished because it was wrong. I remember seeing it on metalink on one occasion, and sending someone a test case that showed that outlines still worked with cursor_sharing if you RAN the code, rather than trying to do 'create ...'. (It's how I'd been doing my 'go_faster' hint for months).

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 Optimising Oracle Seminar - schedule updated Sept 19th

• Original Message ----- From: "Wolfson Larry - lwolfs" <lawrence.wolfson_at_acxiom.com> To: <lawrence.wolfson_at_acxiom.com>; <breitliw_at_centrexcc.com>; "Oracle Discussion List" <oracle-l_at_freelists.org> Sent: Monday, December 20, 2004 6:51 PM Subject: RE: Stored outline problems

I got a reply back from Oracle Support.
They referenced an unpublished Note 132547.1 Using Stored Outlines, Which mentions on page 4:
"Stored outlines are not used when:

o A hint in the stored outline becomes invalid. o CURSOR_SHARING = FORCE

CURSOR_SHARING = FORCE disables the use of stored outlines. CURSOR_SHARING was introduced in Oracle8i Release 2. It internally replaces literals values in queries with bind variables, thus allowing these statements to be shared.

--
http://www.freelists.org/webpage/oracle-l