|
|
|
|
|
|
|
|
| Re: user block - blocking session count [message #296471 is a reply to message #296054] |
Sun, 27 January 2008 17:03   |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess, id1, id2, lmode, request, type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request
/
|
|
|
|
| Re: user block - blocking session count [message #302472 is a reply to message #296054] |
Mon, 25 February 2008 19:27 |
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
|
Junior Member |
|
|
You must to understain that the LOCK is a protect mechanism for integrity of data
You must see ever
the type of lock
the time waiting
the sessions in wait
the results if you choose kill the block session
In grid control console the information is very excepcional and you can evaluate the risks and finaly put the best action
Regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
