-
In Oracle 8.1.7, how could I know which blocks are locked by a session even it's not blocking other sessions?
Thanks.
Queyon
Queyon Zeng
-
-
what do you mean blocks...?
-
One session upates one or two rows of a table.
From V$LOCK, V$LOCKED_OBJECT, I only can see the table name which is being updated. But how can I see which row (ROWID) is being updated within the table?
Thanks.
Queyon
Queyon Zeng
-
you have to download a PRO*C and PL/SQL code from Metalink, even though they are not guaranteed to get to exact results
http://metalink.oracle.com/metalink/...&p_id=132629.1
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
|