ORACLE - List query of User

select
                       a.sid,
                       a.serial#,
                       b.sql_text
from
                       v$session a,
                       v$sqlarea b
where
                       a.sql_address=b.address
                 and a.username='SCHEMA';