I also used spotlight , check top session or sql with data & time option it will give result. But Like you I am not sure it gives all.
Another OEM top session , all cursor will give you all sql open but it does not give which one is running.
I am also trying to find out which query is executed now, but not yet success.
for that purpose I use following script. It's not perfect but works ...
column logon format a22
column sid format 999
column machine format a15
column program format a25
set pagesize 200
set linesize 110
select sid, serial#, machine, program,
to_char(logon_time,'yyyy.mm.dd hh24:mi:ss') logon,
status, first_load_time, sql_text
from v$session, v$sql
order by first_load_time