メモ
select username, osuser, machine, terminal, program,
sid, serial#, status, sql_address, sql_text
from v$session ss, v$sqltext sq
where type = 'USER'
and osuser = XXXXX'
and status = 'ACTIVE'
and ss.sql_address = sq.address
order by ss.osuser, ss.sid, ss.serial#, sq.piece