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

Thanks for the feedback.

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

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

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;