鎖，進程 ，會話，配置文件數據字典

select * from  v$locked_object
select * from v$lock
select spid from v$process p where p.addr='9F2B64FC'
select  * from v$session
select * from v$lock  where kaddr='9F2B64FC'
select * from v$process
select * from v$waitstat
select * from dba_objects where object_id='154624';  
select * from yKEHR.b_employees where  CHNNAME='?撤?'
select object_id,object_name from user_objects where object_name='EMP';  
select * from dba_profiles
select    * from dba_users

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11366721/viewspace-691247/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11366721/viewspace-691247/