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

Thread: update sql tune

  1. #1
    Join Date
    May 2010
    Posts
    1

    update sql tune

    Hi,
    I am getting probelm when i am updating multiple tables in one query.
    Always its gone in hung stage and i am unable to update the records

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Thanks for the feedback.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    how do you know its hung and not just doing the work

    you need to do some basic troubleshooting and work out what it is doing

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Show us the trace file.
    We can not say anything without data.
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Clue


    updating multiple tables in one query.....


    are you sure you ain't locking yourself?
    use this...see if you're not tieing yourself in knots...

    select
    (select username from v$session where sid=a.sid) blocker,
    a.sid,
    ' is blocking ',
    (select username from v$session where sid=b.sid) blockee,
    b.sid
    from v$lock a, v$lock b
    where a.block = 1
    and b.request > 0
    and a.id1 = b.id1
    and a.id2 = b.id2;
    Looking for the greatest evil in the world? Look in the mirror.

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