SELECT 'ALTER SYSTEM KILL SESSION ''' || SID || ',' ||
SERIAL# || ''';' KILL_SQL
, MACHINE
, ORACLE_USERNAME
, OS_USER_NAME
, LOCKED_MODE
, OBJECT_NAME
, OBJECT_TYPE
FROM V$LOCKED_OBJECT A
, DBA_OBJECTS B
, V$SESSION C
WHERE A.OBJECT_ID = B.OBJECT_ID
AND A.SESSION_ID = C.SID
SERIAL# || ''';' KILL_SQL
, MACHINE
, ORACLE_USERNAME
, OS_USER_NAME
, LOCKED_MODE
, OBJECT_NAME
, OBJECT_TYPE
FROM V$LOCKED_OBJECT A
, DBA_OBJECTS B
, V$SESSION C
WHERE A.OBJECT_ID = B.OBJECT_ID
AND A.SESSION_ID = C.SID
'Oracle ERP > DB SCRIPTS' 카테고리의 다른 글
오라클 교육용 SQL Script (0) | 2012.05.31 |
---|---|
table type을 return하는 패키지 function (0) | 2012.04.04 |