oracle实用管理SQL

oracle 查被锁进程

SELECT P.SPID,
       A.SID,
       A.SERIAL#,
       C.OBJECT_NAME,
       B.SESSION_ID,
       B.ORACLE_USERNAME,
       B.OS_USER_NAME
  FROM V$PROCESS       P,
       V$SESSION       A,
       V$LOCKED_OBJECT B,
       ALL_OBJECTS     C
 WHERE P.ADDR = A.PADDR
   AND A.PROCESS = B.PROCESS
   AND C.OBJECT_ID = B.OBJECT_ID;

我的环境查出来结果如下

SPID	SID	SERIAL	OBJECT_NAME	SESSION_ID	ORACLE_USERNAME	OS_USER_NAME
217055	482	5067	GPCS_PLACESUPPLY_	TINY	96	GDZTZS2
217053	290	8121	GPCS_PLACESUPPLY_TINY	96	GDZTZS2	Administrator
217051	6	52082	GPCS_PLACESUPPLY_TINY	96	GDZTZS2	Administrator
163207	1713	40204	GPCS_PLACESUPPLY_TINY	96	GDZTZS2	Administrator

杀死进程

alter system kill session ‘sid,serial#’;

我的环境查执行如下

alter system kill session ‘482 ,5067 ’;