-- ss单位是秒 select * from ( select ( SELECT round(SUM(TOTAL_SIZE/1024/1024), 2) FROM V$MEM_POOL C where C.name VIRTUAL MACHINE AND C.CREATOR A.THRD_ID GROUP BY CREATOR )AS VM_TOTAL_SIZE_BY_M, a.trx_id , last_recv_time, a.thrd_id , clnt_ip , last_recv_time, c.ROLLBACK_FLAG , sp_close_session( ||a.sess_id ||); , curr_sch , B.IO_WAIT_TIME/1000 as IO_WAIT_TIME , TO_CHAR(sf_get_session_sql(a.sess_id)) , datediff(ss, last_recv_time, sysdate) ss, B.LOGIC_READ_CNT , B.RECYCLE_LOGIC_READ_CNT , sql_text , c.ins_cnt , c.upd_cnt , c.del_cnt , a.CONNECTED , a.state , a.appname , a.clnt_ver , a.clnt_host from V$sessions A, V$SQL_STAT B, v$trx c where state in(ACTIVE, WAIT) AND A.SESS_ID B.SESSID and a.trx_id c.id AND A.SESS_ID C.SESS_ID ) order by ss desc