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

Thread: Update taking lots of time.

  1. 10-15-2002, 09:54 AM #1
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Hi Friends,
    I'm facing a very strange problem. One developer came to me and asked that one simple update statement, which updates only one row in a table with 50 records, is taking a lot of time...some 15 mins...
    But same query is running fine in other developer's session...it comes at the speed of light...
    Now the scene is that few developers are taking much time in running the query and for some it is coming at the speed of light. Here is the query. My Oracle8.1.6 running on Windows-NT.

    UPDATE bkp_ref_region SET last_update_date = sysdate,region_id='REG22',region_desc='region',region_LVL=5,PARENT_ID='REG2',CURRENCY_CODE='ARS',STA TUS=1 WHERE region_id='REG22'

    Please tell me what could be the problem.
    Thanks in advance
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
  2. 10-15-2002, 10:20 AM #2
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    I'm sorry friends...I'm running on Oracle 9.0.1.1.1 on Windows-NT. Developers have oracle 8.1.6 client.
    Thanks
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
  3. 10-15-2002, 10:55 AM #3
    np70
    np70 is offline Junior Member
    Join Date
    Mar 2001
    Posts
    71
    it may be because user1 is trying to update same record user2
    has locked. once user2 commits changes, update for user1 finishes.

    np70
    Reply With Quote Reply With Quote
  4. 10-15-2002, 11:45 AM #4
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    I tried that, but this is not the case. as I told I can see the result of the same query in some other session in some other machine. For some users it will work fine but for some it won't.
    Don't know what's happening. Rollback segs, temp segs are all fine...
    lot of space in datafile also...
    any clue...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
  5. 10-15-2002, 12:19 PM #5
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Try to use 'select for update nowait' if it is locked by other transaction you will see it.

    Originally posted by sandycrab
    I tried that, but this is not the case. as I told I can see the result of the same query in some other session in some other machine. For some users it will work fine but for some it won't.
    Don't know what's happening. Rollback segs, temp segs are all fine...
    lot of space in datafile also...
    any clue...
    Sandy
    [Edited by kgb on 10-15-2002 at 12:25 PM]
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  6. 10-15-2002, 01:44 PM #6
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    is bkp_ref_region indexed?

    stats generated?

    steve
    I'm stmontgo and I approve of this message
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width