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