oracle 查询死锁、免密登录、创建删除用户

SELECT s.sid, s.serial# FROM v$locked_object lo, dba_objects ao, v$session s 
 WHERE ao.object_id = lo.object_id AND lo.session_id = s.sid;

解决死锁：

ALTER system KILL session 'SID,serial#'

oracle 递归从父到子遍历所有的节点

select * from t_rg_station start with sid='210012' connect by prior sid=up_sid 

 

=========================【免密 登录】===================

 如何在锁住的情况下登录系统

在dos后输入
sqlplus /nolog
之后
conn sys / as sysdba
就能实现登陆

 

 

如果账户被锁定

alter user [username] account unlock;

 

========================【删除  创建  用户】=====================

drop user 用户名 cascade;---cascade 级联

//给用户授予权限

create user username identified by password 

grant connect,resource，dba  to username;

 

 

========================【session 被锁定  处理方式】=====================

 select session_id from v$locked_object;
 
 
 SELECT sid, serial#, username, osuser FROM v$session where sid = 132;
 
 
 ALTER SYSTEM KILL SESSION '132,571';