Oracleで特定のOSユーザーが実行中のSQLを出力するSQL

メモ

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