SQL> SELECT s.username, q.sql_text
FROM v$process p,v$session s,v$sqlarea q,v$sql sq
WHERE s.sql_address=q.address AND p.addr=s.paddr AND s.username !='SYS'
AND q.hash_value=sq.hash_value
ORDER BY q.cpu_time DESC
/  2    3    4    5    6
SQL> SELECT s.username, q.sql_text FROM v$process p,v$session s,v$sqlarea q,v$sql sq WHERE s.sql_address=q.address AND p.addr=s.paddr AND s.username !='SYS' AND q.hash_value=sq.hash_value ORDER BY q.cpu_time DESC
  2
SQL>
SQL>  SELECT s.username, q.sql_text FROM v$process p,v$session s,v$sqlarea q,v$sql sq WHERE s.sql_address=q.address AND p.addr=s.paddr AND s.username !='SYS' AND q.hash_value=sq.hash_value ORDER BY q.cpu_time DESC /
  2
SQL>