Oracle Slowing Down Each turn - Newbie
From: Gene Ariani <karadur_at_comcast.net>
Date: Tue, 20 Jul 2004 18:02:36 -0400
Message-ID: <oKWdnbbXkpb1C2DdRVn-rA_at_comcast.com>
I am fairly new to Oracle and I would appreciate if some one can point me to a right direction.
Date: Tue, 20 Jul 2004 18:02:36 -0400
Message-ID: <oKWdnbbXkpb1C2DdRVn-rA_at_comcast.com>
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 Received on Wed Jul 21 2004 - 00:02:36 CEST