update sql tune
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
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.
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 username from v$session where sid=a.sid) blocker,
' is blocking ',
(select username from v$session where sid=b.sid) blockee,
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.
Click Here to Expand Forum to Full Width