oracle存储过程无法编译、表数据无法修改

1、--存储过程无法编译SELECT V.OSUSER, V.PROCESS,V.PROGRAM巳呀屋饔,v.MACHINE,V.TERMINAL,V.MODULE,V.USERNAME,V.STA皈其拄攥TUS,V.SID,V.SERIAL#, 'alter system kill session ''' || V.sid || ',' || V.SERIAL# || ''';' as KILL_SESSION, V.PADDR FROM V$SESSION VWHERE V.USERNAME LIKE '%用户名%' AND V.STATUS in( 'INACTIVE','ACTIVE') and v.PROGRAM = 'plsqldev.exe';

2、--表无法修改，复制KILL_SESSION列的sql语句执行SELECT object_name, machine, s.sid, s.serial# ,'alter system kill session ''' || s.sid || ',' || s.SERIAL# || ''';' as KILL_SESSION FROM gv$locked_object l, dba_objects o, gv$session sWHERE l.object_id　= o.object_idAND l.session_id = s.sid;