SELECT D.USERNAME , A.VALUE CPU_USAGE , A.SID , D.SERIAL# , D.BLOCKING_SESSION_STATUS , C.SQL_FULLTEXT FROM V$SESSION D, V$SESSTAT A, V$STATNAME B, V$SQLAREA C WHERE A.SID = D.SID AND A.STATISTIC# = B.STATISTIC# AND B.NAME LIKE '%CPU used by this session%' AND D.PREV_SQL_ID = C.SQL_ID -- AND D.BLOCKING_SESSION_STATUS = 'VALID' AND ROWNUM