If you're referring too ACTIVE connections by saying REAL than you can use the following to list the ACTIVE sessions:

select p.spid THREADID, s.username, s.program,s.status,s.paddr
from v$process p, v$session s
where p.addr=s.paddr
and s.status='ACTIVE';