Active Sql Monitor

SYS AS SYSDBA>l
1 select sesion.sid,
2 sesion.serial#,
3 sesion.username,
4 sesion.sql_id,
5 sesion.sql_child_number,
6 optimizer_mode,
7 hash_value,
8 address,
9 sql_text
10 from v$sqlarea sqlarea, v$session sesion
11 where sesion.sql_hash_value = sqlarea.hash_value
12 and sesion.sql_address = sqlarea.address
13 and sesion.username is not null
14* and sql_text not like 'select sesion.sid,%'