Home » RDBMS Server » Performance Tuning » SQL & PL/SQL
SQL & PL/SQL [message #601730] Mon, 25 November 2013 01:34 Go to next message
Messages: 1
Registered: November 2013
Junior Member
I am trying to test archiving on one schema. But below update query takes too much time to run.The same query runs on other schema properly.
please suggest solution.

Re: SQL & PL/SQL [message #601731 is a reply to message #601730] Mon, 25 November 2013 02:04 Go to previous message
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
Hi and welcome to Orafaq. You have posted, basically, no useful information.
Take a look at this page , spend some time understanding the content of the links, read the posts and understand them, then if you're still having problems, post back paying particular attention to Blackswan's post
Previous Topic: Performance degrade
Next Topic: fast query
Goto Forum:

Current Time: Tue Aug 22 06:18:42 CDT 2017

Total time taken to generate the page: 0.01345 seconds