oracle db 死锁

--查找锁死的session

select a.object_name, b.session_id,
c.serial#, c.username,c.command,c.machine,
c.lockwait from all_objects a,v$locked_object b,
v$session c where a.object_id=b.object_id and c.sid=b.session_id;

--查找正在运行的sql

select machine,a.username,a.sid,b.sql_text from v$session a,v$sqlarea b where a.sql_address=b.address

 

--杀死session

alter system kill session'290,    20';--290为 session_id  20为 serial#

 

 

 1. 查询oracle中所有用户信息

       select  * from dba_users;

   2. 只查询用户和密码

       select username,password from dba_users; 

   3. 查询当前用户信息

       select * from dba_ustats;

   4. 查询用户可以访问的视图文本

       select * from dba_varrays;

   5. 查询数据库中所有视图的文本

       select * from dba_views;