Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Bind Variables Using ODP.NET

Re: Bind Variables Using ODP.NET

From: <sybrandb_at_yahoo.com>
Date: 23 Feb 2006 00:57:38 -0800
Message-ID: <1140685058.397911.223810@e56g2000cwe.googlegroups.com> 





You are creating the statement *inside* the for loop. You are not
re-using the implicit cursor.


Consequently you are getting 1 hard parse and n-1 soft parses. Parse is
the most costly operation there is in terms of cpu.
Please sql trace your code and verify this is correct.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Thu Feb 23 2006 - 02:57:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US