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_at_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 Wed Jul 21 2004 - 03:30:20 CEST

Original text of this message