You can get the information of a specific session from v$session and v$open_cursor views, like in this example:
select sid, user_name, sql_text, address
where sid in (
from v$session v_s
where v_s.program like ‘%LadProc%’)
and sql_text like ‘SELECT%’
order by sid,address
Here i’m looking for all currently active select statements of a specific Process “LadProc”.
You can also filter on v$session.username.
I hope this can help.