Oracle - View running processes

SELECT sess.process, sess.status, sess.username, sess.schemaname, SQL.sql_text
  FROM v$session sess,
       v$sql     SQL
 WHERE SQL.sql_id(+) = sess.sql_id
 ORDER BY username;