Query to find SQL AREA using Client OS User (or) Oracle DB user

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


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

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