junfei的专栏

select o.* from T_COL o where CONNECT_BY_ISLEAF =1 start with o.COL_ID = xxx connect by prior o.COL_ID =o.PARENT_ID

1、查询出被锁的情况：SELECT OBJECT_ID,SESSION_ID,SERIAL#, ORACLE_USERNAME,OS_USER_NAME,S.PROCESS FROM V$LOCKED_OBJECT A, V$SESSION S WHERE A.SESSION_ID=S.SID 2、解锁：alter system kill session 'sid,se...