摘要：
1常见视图select sid from v$mystat where rownum=1;(当前会话id)select sid,type,id1,id2,request,lmode,block from v$lock where type in ('TM','TX');(查看锁对象)--block=1 说明它阻塞了其他会话select machine from v$session where sid in(158);(查看访问的主机名称)select object_name ,subobject_name from dba_objects where objec 阅读全文