DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Select .. . . . . . for Update

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    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
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width