这个试下

   SELECT CAST( M.TS * 1.0 / 1024 / 1024 AS NUMBER(38, 2)) AS "内存MB",
          DATEDIFF(SS, LAST_RECV_TIME, SYSDATE)            AS "运行时间S",
          USER_NAME,
          DBMS_LOB.SUBSTR(SF_GET_SESSION_SQL(SESS_ID)) AS "执行SQL",
          THRD_ID || '  ' || APPNAME || '  ' ||        CLNT_IP,
          DATEDIFF(SS, LAST_SEND_TIME, SYSDATE)        AS "会话建立时长",
          'SP_CLOSE_SESSION(' || SESS_ID || ');'
     FROM V$SESSIONS              S
LEFT JOIN (SELECT SUM(TOTAL_SIZE) TS,
                   CREATOR
              FROM V$MEM_POOL
          GROUP BY CREATOR) M
       ON S.THRD_ID = M.CREATOR
--    WHERE STATE IN('WAIT','ACTIVE')
 ORDER BY "内存MB" DESC ;