How to check logged username by PID in Oracle

You can easily check you currently logged to your Oracle DB by Linux command:

ps -ef|grep oracleNameOfSID

In my case my DB's SID is cdrsmsc

Take the PID (process ID) from second column and run below query;

select A.ADDR,B.PADDR,B.USERNAMe from v$process a, v$session b

where A.SPID='PID_of_Process'

and B.PADDR=A.ADDR

In my case for example: