Technology sharing

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

1. Locked Sessio Query

--被锁Session
SELECT GV$SESSION.SID, GV$SESSION.SERIAL#
	,DBA_OBJECTS.OBJECT_NAME
	,GV$SESSION.OSUSER
	,GV$SESSION.PROGRAM
FROM GV$LOCKED_OBJECT
LEFT JOIN  DBA_OBJECTS
ON GV$LOCKED_OBJECT.OBJECT_ID = DBA_OBJECTS.OBJECT_ID
LEFT JOIN GV$SESSION
ON GV$LOCKED_OBJECT.SESSION_ID = GV$SESSION.SID
ORDER BY GV$SESSION.SID, DBA_OBJECTS.OBJECT_NAME;

2. Locked SQL query

--被锁SQL查询
SELECT GV$SESSION.SID, GV$SESSION.SERIAL#,GV$SQLAREA.SQL_TEXT,GV$SQLAREA.ADDRESS
 FROM GV$SQLAREA, GV$SESSION, GV$LOCK
 WHERE GV$SQLAREA.ADDRESS = GV$SESSION.SQL_ADDRESS
 AND GV$SESSION.SID = GV$LOCK.SID
 AND GV$LOCK.TYPE IN ('TX','TM')