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

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

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@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 Tue Jul 20 2004 - 17:02:36 CDT












Original text of this message













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