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

Home -> Community -> Usenet -> c.d.o.server -> Stored proc slower than direct sql query. Help needed

Stored proc slower than direct sql query. Help needed

From: JGP <deja_at_chothu.mailshell.com>
Date: 10 Apr 2002 12:07:17 -0700
Message-ID: <1e9cd49d.0204101107.486f31fb@posting.google.com> 





Hi,



I've run into a frustrating problem and I just can't seem to find a
solution. I have a function which has a fairly complicated Insert
statement. When I compile and execte the function with parameters, it
takes about 5-10 mins and the oracle machine CPU becomes extremely
loaded. When I directly run the Insert statement which was in the
function, it does it much faster within 30 secs. Can someone please
help. Thanks.



JGP

Received on Wed Apr 10 2002 - 14:07:17 CDT












Original text of this message













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