update sql tune

[anwar.shaikh]

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

[stecal]

Thanks for the feedback.

[davey23uk]

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

[malay_biswal]

Show us the trace file.
We can not say anything without data.

[Tuma]

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;