SELECT ALL ALL_OBJECTS.OWNER, ALL_OBJECTS.OBJECT_NAME, ALL_OBJECTS.OBJECT_TYPE, V$LOCKED_OBJECT.ORACLE_USERNAME, V$LOCKED_OBJECT.OS_USER_NAME, DECODE(V$LOCKED_OBJECT.LOCKED_MODE, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', 'Unknown') LockMode, V$SESSION.MACHINE, V$SESSION.PROGRAM, V$SESSION.LOGON_TIME, V$SESSION.TERMINAL, V$SESSION.SID, V$SESSION.SERIAL# FROM V$LOCKED_OBJECT, ALL_OBJECTS, V$SESSION WHERE ((ALL_OBJECTS.OBJECT_ID=V$LOCKED_OBJECT.OBJECT_ID) AND (V$LOCKED_OBJECT.SESSION_ID=V$SESSION.SID));
Rants and ravings of a semi-autistic developer who has a hard time remembering idiotic nonsense details. Why remember it, when you know where to find it.
Wednesday, December 29, 2010
Oracle: Reading Table Locks And From Where
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment