ํ ์ด๋ธ ๋ฝ LOCK TABLE ํ ์ด๋ธ๋ช IN EXCLUSIVE MODE; ๋ฝ์ด ๊ฑธ๋ฆฐ ํ ์ด๋ธ ํ์ธ select * from v$locked_object where oracle_username = '์ฌ์ฉ์๋ช '; ๋ฝ์ด ๊ฑธ๋ ค์๋ ํ ์ด๋ธ ๊ฐฏ์ ํ์ธ select count(*) from v$locked_object vo , dba_objects do where vo.object_id = do.object_id; ๋ฝ ๊ฑธ๋ฆฐ ์ธ์ ํ์ธ 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.s..