--当前会话的SID
select sid from v$mystat where rownum=1;
select userenv("sid") from dual;
--trc文件
select tracefile from v$process where addr in (select paddr from v$session
开锁
select object_id,session_id,locked_mode from v$locked_object;--查看数据库锁
select b.OWNER ,b.OBJECT_NAME,l.SESSION_ID,l.LOCKED_MODE from v$locked_object l,dba_objects b where b.OBJECT_ID = l.O
