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
Printable View
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;