Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored proc slower than direct sql query. Help needed
"JGP" <deja_at_chothu.mailshell.com> wrote in message
news:1e9cd49d.0204101107.486f31fb_at_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
If you want help please don't be intentionally vague and post the source of
your procedure. Crystal balls are not being sold here
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Wed Apr 10 2002 - 15:05:46 CDT