SID    SERIAL# USERNAME    LOGON_TIME                STATUS   AUTHENTICATION_TYPE  OSUSER     CLIENT_CONNECTION  CLIENT_VERSION  CLIENT_DRIVER
---------- ---------- ----------- ------------------------- -------- -------------------- ---------- ------------------ --------------- ---------------------
       794      32263 SYS         NOV-05-2020 02:46:54 AM   ACTIVE   INTERNAL             oracle     Homogeneous        12.2.0.1.0      SQL*PLUS
      1689      11642 TESTUSER    NOV-05-2020 03:31:54 AM   INACTIVE DATABASE             machine1   Heterogeneous      19.7.0.0.0      jdbcthin : 19.7.0.0.0
----------------------------------------------------------
-----------------------Trimmed Data-----------------------
----------------------------------------------------------
      1553      56673 SUNNY      OCT-30-2020 09:26:02 PM   INACTIVE DATABASE             oracle     Heterogeneous      11.2.0.3.0      jdbcthin

SQL>
$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The below output is the same as above along with the additional column NETWORK_SERVICE_BANNER where you can see output 3-4 rows for the same SID due to depends on the network banner of the connected client.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


       SID    SERIAL# USERNAME    LOGON_TIME                STATUS   AUTHENTICATION_TYPE  OSUSER     CLIENT_CONNECTION  CLIENT_VERSION  CLIENT_DRIVER
---------- ---------- ----------- ------------------------- -------- -------------------- ---------- ------------------ --------------- ---------------------
NETWORK_SERVICE_BANN
--------------------
	   794      35138 SYS         NOV-05-2020 04:00:51 AM   ACTIVE   INTERNAL             oracle     Homogeneous        12.2.0.1.0      SQL*PLUS
Encryption service f
or Linux: Version 12
.2.0.1.0 - Productio
n

       794      35138 SYS         NOV-05-2020 04:00:51 AM   ACTIVE   INTERNAL             oracle     Homogeneous        12.2.0.1.0      SQL*PLUS
Oracle Bequeath NT P
rotocol Adapter for
Linux: Version 12.2.
0.1.0 - Production

       794      35138 SYS         NOV-05-2020 04:00:51 AM   ACTIVE   INTERNAL             oracle     Homogeneous        12.2.0.1.0      SQL*PLUS
Authentication servi
ce for Linux: Versio
n 12.2.0.1.0 - Produ
ction

       794      35138 SYS         NOV-05-2020 04:00:51 AM   ACTIVE   INTERNAL             oracle     Homogeneous        12.2.0.1.0      SQL*PLUS
Crypto-checksumming
service for Linux: V
ersion 12.2.0.1.0 -
Production

      1689      11642 TESTUSER    NOV-03-2020 04:53:00 AM   INACTIVE DATABASE             machine1   Heterogeneous      12.2.0.1.0      jdbcthin : 12.2.0.1.0
Crypto-checksumming
service for Linux: V
ersion 12.2.0.1.0 -
Production

      1689      11642 TESTUSER    NOV-03-2020 04:53:00 AM   INACTIVE DATABASE             machine1   Heterogeneous      12.2.0.1.0      jdbcthin : 12.2.0.1.0
TCP/IP NT Protocol A
dapter for Linux: Ve
rsion 12.2.0.1.0 - P
roduction

      1689      11642 TESTUSER    NOV-03-2020 04:53:00 AM   INACTIVE DATABASE             machine1   Heterogeneous      12.2.0.1.0      jdbcthin : 12.2.0.1.0
Encryption service f
or Linux: Version 12
.2.0.1.0 - Productio
n

----------------------------------------------------------
-----------------------Trimmed Data-----------------------
----------------------------------------------------------       


SQL>
$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$