DUH! Use distinct clause in sub query

select distinct sid from v$session_connect_info