oracle.txt

selectSESS.sid,SESS.SERIAL#,LO.ORACLE_USERNAME,LO.OS_USER_NAME,AO.OBJECT_NAME,LO.LOCKED_MODEfromV$LOCKED_OBJECTLO,DBA_OBJECTsAO,V$SESSIONSESSwhereAO.OBJECT_ID=LO.OBJECT_IDandlo.session_id=sess.sid;altersystemkillsession'sid,serial#';altersystemkillsession'173,16112';