Re: 9i Parsing Optimization

I don't know what technology Siebel Tools uses, but your earlier double call may have been a "feature" of the ODBC or JDBC or whatever driver was between Siebel and Oracle, rather than a bit of the application code.

I believe there used to be a feature in the Perl driver, for example, that made it do a parse call without bind values, followed by an execute call with bind values - but if the bind types weren't all character, the execute call would require a second parse call. It's something like that that may have gone away on the upgrade.

Don't ask me to quote specifics - it's a long time ago and in another version.

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

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

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "amonte" <ax.mount_at_gmail.com> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> Sent: Wednesday, August 30, 2006 9:50 PM Subject: Re: 9i Parsing Optimization

> Anjo and Brandon, I forgot to mention we use RULE BASED OPTIMIZER so
> permutations shouldnt be a problem. This is not PL/SQL so it cant be some
> pl/sql optimization. This is a Siebel Workflow Manager Process.
>
> Jonathan, it is Siebel Tools, I understand that from application codes you
> can invoke two parse calls but what I dont understand is why the second call
> is not "called" in 9i?
>
> TIA
>
> Alex

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