Oracle Archives - SilverNine Area

오라클 CONNECT BY PRIOR

SELECT * FROM TABLE
START WITH 기준칼럼 = ‘값’
CONNECT BY PRIOR 자식칼럼 = 기준칼럼;

SELECT * FROM TABLE

START WITH 기준칼럼 = ‘값’

CONNECT BY PRIOR 자식칼럼 = 기준칼럼;

1. 락 세션 확인

SELECT a.sid, a.serial#
FROM v$session a
, v$lock b
, dba_objects c
WHERE a.sid =b.sid
AND b.id1 =c.object_id
AND b.type=’TM’;

SELECT a.sid, a.serial#

FROM v$session a

, v$lock b

, dba_objects c

WHERE a.sid =b.sid

AND b.id1 =c.object_id

AND b.type=’TM’;

2. 락 세션 해제

ALTER system kill session ‘sid, serial#’;

COMMIT;

ALTER system kill session ‘sid, serial#’;

COMMIT;