give select * from v$session .

That will give who are all connected as what user and from which terminals.