查询某张表的会话进程id,有时候会话关闭了，但是进程还在，这样就会造成这张表还被使用，

 SELECT SID,SERIAL# FROM GV$SESSION V 
   WHERE SID IN (SELECT SID FROM GV$LOCK  L,DBA_OBJECTS O 
          WHERE L.ID1 = O.OBJECT_ID AND O.OBJECT_NAME =UPPER('TEMP_FSF_GJXX')   );
          

ALTER SYSTEM KILL SESSION '20,2661';