From: Xbricklen@yahoo.comX   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)