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 -> Re: Stored proc slower than direct sql query. Help needed

Re: Stored proc slower than direct sql query. Help needed

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 22:05:46 +0200
Message-ID: <ub97bg51rhb911@corp.supernews.com>

"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 address
Received on Wed Apr 10 2002 - 15:05:46 CDT

Original text of this message

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