Re: 9i Parsing Optimization
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 21:58:25 +0100
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@xxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
