Update taking lots of time.

[sandycrab]

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

[sandycrab]

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

[np70]

it may be because user1 is trying to update same record user2
has locked. once user2 commits changes, update for user1 finishes.

np70

[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

[kgb]

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]

[stmontgo]

is bkp_ref_region indexed?

stats generated?

steve