Home » Other » Test » Stored Procedure Running Continuously (Oracle 10G)
Stored Procedure Running Continuously [message #356959] Mon, 03 November 2008 06:00 Go to next message
madhava.maganti
Messages: 4
Registered: February 2008
Location: Mumbai
Junior Member

We have one preparation stored procedure with set of DDL (Insert,Update Delete) and TCL(Commit, Rollback) statements. This stored procedure is calling by one of the Informatica workflow. Now the problem is stored procedure sometimes will take long time(upto 6hrs) to finish the process and the same stored procedure sometimes will also finish the execution in between 15 to 20 mins.

We are having this issue from past 6 months but from past 6 months we have a temporary solution to rebuilding indexes and analyzing the statistics manually. But now we automate that process (Rebuilding Indexes) it in one stored procedure. Even though we are facing same problem(take long time to finish the process. Please advice how should I overcome this issue.

Thanks in Advacne!
Madhava
Re: Stored Procedure Running Continuously [message #357536 is a reply to message #356959] Wed, 05 November 2008 16:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This was a good test. I suggest in future using the spell-checker.

David
Previous Topic: test
Next Topic: find_string
Goto Forum:
  


Current Time: Thu Oct 23 05:14:11 CDT 2014

Total time taken to generate the page: 0.14132 seconds