Select .. . . . . . for Update

Hi,

I am having a query.

SELECT
*
FROM
"NRIV"
WHERE
"CLIENT" = :A0 AND "OBJECT" = :A1 AND "SUBOBJECT" = :A2 AND "NRRANGENR" = :A3
AND "TOYEAR" = :A4
FOR UPDATE


This is taking lot of time, to the tune of 800 secs sometimes.
It is waiting at enqueue.

NRIV Table s having 7066 Rows Only. Also has only One Index.

Can anyone help me in this ??


Regards
Vijay

Is this part of a control structure (FOR...LOOP) using multiple cursors. If so you may have to check your cursor definition.

Check the following link ...
http://dbasupport.com/forums/showthr...threadid=33107

HTH.