oracle 查询哪些进程耗费资源以及拼接杀进程语句

SELECT        x.SQL_TEXT,
      'ALTER SYSTEM KILL SESSION ''' || S.SID || ',' || S.SERIAL# || ''';','kill -9 '||SPID,
       S.SID,
       S.SERIAL#,
       S.USERNAME, 
       S.MACHINE,
       S.SQL_HASH_VALUE,
       S.LAST_CALL_ET,S.LAST_CALL_ET/60,
       CLIENT_INFO,
       S.STATUS
  FROM V$SESSION S, V$PROCESS P, V$SQLTEXT x
 WHERE (P.ADDR(+) = S.PADDR)
   AND S.USERNAME IS NOT NULL
   and x.HASH_VALUE= S.SQL_HASH_VALUE
   --AND SPID='5275666'
   AND S.STATUS = 'ACTIVE'
   --and s.USERNAME = 'GCMSDW'
  -- AND S.MACHINE LIKE '%TL%'
 ORDER BY LAST_CALL_ET DESC, S.USERNAME ASC,x.HASH_VALUE,x.PIECE;