When we are preparing to move a database or something like that, it’s useful to know if there is any session connecting by SID, right?
It can be done with:
select distinct machine,username,inst_id from gv$session where service_name = 'SYS$USERS';
Cheers!