Monday, 5 May 2014


TOTAL BLOCKING SESSION

SELECT COUNT(*)  FROM  V$LOCK  WHERE  BLOCK=’1’;

TOTAL LOCKED OBJECTS

SELECT COUNT(*) FROM V$LOCKED_OBJECTS;

TO KILL LOCAL=NO PROCESS

PS –EF |GREP LOCAL=NO
KILL -9
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)