Home » SQL & PL/SQL » SQL & PL/SQL » Erratic Procedure behaviour
Erratic Procedure behaviour [message #213542] Thu, 11 January 2007 03:42 Go to next message
apramodh
Messages: 8
Registered: March 2006
Location: Texas, USA
Junior Member
have 2 tables A and B. A and B are populated by 2 large queries. After populating A and B another procedure runs on A and B and inserts data after processing into another table C.

The procedure consists of multiple cursors. A, B and C are truncated before data load.
The issue is as follows:
The procedure runs in around 1-2 minutes. But, at times it slows down considerably taking approx.20-30 minutes to run. If table A and B are truncated, dropped and recreated then the same procedure runs again in 1-2 minutes. What could be the issue?

No other batch is running at the same time. Has anybody encountered this situation before?
Re: Erratic Procedure behaviour [message #213680 is a reply to message #213542] Thu, 11 January 2007 19:01 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
High Water Mark

Ross Leishman
Re: Erratic Procedure behaviour [message #215125 is a reply to message #213542] Fri, 19 January 2007 07:06 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
DBMS_PROFILER
Previous Topic: Optimizer Choosing a Path with higher cost
Next Topic: Disable Trigger via DB Link
Goto Forum:
  


Current Time: Fri Dec 09 09:27:42 CST 2016

Total time taken to generate the page: 0.08355 seconds