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
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!
Re: Stored Procedure Running Continuously [message #357536 is a reply to message #356959] Wed, 05 November 2008 16:39 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
This was a good test. I suggest in future using the spell-checker.

Previous Topic: test
Next Topic: Which view would you query to identify the space utilization settings for tables owned by the APPS u
Goto Forum:

Current Time: Wed Aug 23 22:17:31 CDT 2017

Total time taken to generate the page: 0.23813 seconds