Home » RDBMS Server » Performance Tuning » SQL & PL/SQL
SQL & PL/SQL [message #601730] Mon, 25 November 2013 01:34 Go to next message
varshbugad
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.

UPDATE OW_WORKITEM_INSTANCE SET ARCHIVEPROCESS_COUNT=1 WHERE WORKITEMID=3556;
Re: SQL & PL/SQL [message #601731 is a reply to message #601730] Mon, 25 November 2013 02:04 Go to previous message
pablolee
Messages: 2617
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: Locking In application code.
Next Topic: Please help me my query performance is bad.
Goto Forum:
  


Current Time: Mon Sep 22 17:42:55 CDT 2014

Total time taken to generate the page: 0.14037 seconds