How to know the opened connections ?

Go to SQL prompt.

Use any of the command from below : 

Sql> Desc v$session;

Sql> select USERNAME, SERVER, MACHINE,OSUSER from v$session;

Sql> select OSUSER from v$session;