SELECT sid
FROM v$session
WHERE audsid = userenv('SESSIONID');

You can have more sessions with the same username.