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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Oracle Slowing Down Each turn - Newbie

Re: Oracle Slowing Down Each turn - Newbie

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Wed, 21 Jul 2004 01:30:20 GMT
Message-ID: <MGjLc.74689$ek5.56284@pd7tw2no>


Gene Ariani wrote:

> I am fairly new to Oracle and I would appreciate if some one can point me to
> a right direction.
>
> I have store procedure that takes about 3 minutes to run. If I run the same
> procedure again suddenly it takes 7 minutes to un and some time up to thirty
> minutes to run. There is no traffic on this server at this time and its a
> test server.
>
> And then suddenly it takes 3 minutes to run again.
>
>
> Any help is appreciated it.
>
>
> Gene
>
>

Post your code, oracle version, os, etc Received on Tue Jul 20 2004 - 20:30:20 CDT

Original text of this message

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