-
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
-
-
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;
Looking for the greatest evil in the world? Look in the mirror.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|