dbTalk Databases Forums  

Oracle Slowing Down Each turn - Newbie

Go Back dbTalk Databases Forums Databases comp.databases.oracle Oracle Slowing Down Each turn - Newbie

comp.databases.oracle comp.databases.oracle


Discuss Oracle Slowing Down Each turn - Newbie in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gene Ariani
 
Posts: n/a

Default Oracle Slowing Down Each turn - Newbie - 07-20-2004 , 05:02 PM





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



Reply With Quote
  #2  
Old   
Bricklen
 
Posts: n/a

Default Re: Oracle Slowing Down Each turn - Newbie - 07-20-2004 , 08:30 PM





Gene Ariani wrote:

Quote:
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


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top