oracle 常用sql

ps -ef|grep oracleshdw2 |grep -v grep | awk '{print $2}' | xargs kill -9

select sid,type,id1,id2,
decode(lmode,0,'None',1,'Null',2,'Row share',3,'Row Exclusive',4,'Share',
5,'Share Row Exclusive',6,'Exclusive') lock_type,request,ctime,block 
from 
v$lock 
where type in('TX','TM');


查询被锁对象
SELECT a_s.owner, 
  a_s.object_name, 
  a_s.object_type, 
  VN.SID, 
  VN.SERIAL#, 
  VS.SPID "OS_PID", 
  VN.PROCESS "CLIENT_PID", 
  VN.USERNAME, 
  VN.OSUSER, 
  VN.MACHINE "HOSTNAME" , 
  VN.TERMINAL, 
  VN.PROGRAM, 
  TO_CHAR(VN.LOGON_TIME,'YYYY-MM-DD HH24:MI:SS')"LOGIN_TIME", 
  'alter system kill session '''||vn.sid||','||vn.serial#||''';' "ORACKE_KILL", 
  'kill -9 '|| VS.SPID "OS_KILL"
FROM ALL_OBJECTS A_S, 
  V$LOCKED_OBJECT V_T, 
  V$SESSION VN, 
  V$PROCESS VS