Slow PL/SQL Execution [message #41223] |
Wed, 11 December 2002 02:13 |
Subramaniam.R
Messages: 2 Registered: December 2002
|
Junior Member |
|
|
Hello Friends,
I have a stored procedure which has been running for quite some time successfully in about 1/2 hour populating about 20 million records in a target table. Of late i.e in the last 1 week, I find the same to be taking about 20 hours to complete. Actually about 19.5 million records get loaded into the first 20 minutes. The last 0.5 million records take about 19 1/2 hours......Can anyone throw some light on the same..There has been no change on the Base table and corresponding indexes......
Thanks
Subramaniam.R
|
|
|
Re: Slow PL/SQL Execution [message #41227 is a reply to message #41223] |
Wed, 11 December 2002 06:34 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
1. Rebuild your indexes.
2. Clear your TEMP segments
3. look for ROLLBACK SEGEMENT CONTENTION and LOG CONTENTION( log switches).
4. First look into execution plan
|
|
|