SQL & PL/SQL

We are attempting to write a Oracle Update Statement to update a value on all records in a single column. We are updating a column with a value found in a history table. Simple enough. We do it all the time. It works but we are having contention issue with users on the system using the main database threads and updating the same table at the same time. So what is happening is the update uses up all the available database threads and then the users just get timeouts and can't update. What we are trying to determine is can I write it to force the update statement to use a specific thread on the database when it is running?


Here is the current update statement

UPDATE
TASK_DATA TSK
SET
dttSTATUS_WORK_IN_PROGRESS_TIM =
(
SELECT
HIS.T5
FROM
H2839 HIS
WHERE
TSK.REQUEST_ID = HIS.ENTRYID
AND
HIS.T5 IS NOT NULL
AND
TSK.dttSTATUS_WORK_IN_PROGRESS_TIM IS NULL
)

Edited by: user11307503 on Oct 21, 2009 3:47 PM