Output of SQL command to find last successful login date using DBA_USERS (12c onward version). 

USERNAME                  ACCOUNT_STATUS      LOCK_DATE EXPIRY_DATE   LAST_LOGIN
------------------------- ------------------- --------- ------------- -----------------------------------------
ANONYMOUS                 EXPIRED & LOCKED    26-JAN-17 26-JAN-17
-------------------------------------------------TRIMMED DATA--------------------------------------------------
DBSNMP               OPEN                                        18-NOV-20 06.27.13.000000000 AM -05:00
TEST11               OPEN                                        18-NOV-20 06.26.01.000000000 AM -05:00
TEST12               OPEN                                        17-NOV-20 11.01.16.000000000 AM -05:00
TEST13               OPEN                                        06-NOV-20 03.23.18.000000000 PM -05:00
TEST14               OPEN                                        22-SEP-20 01.53.36.000000000 PM -05:00
DBSGURU              OPEN                                        22-SEP-20 01.53.03.000000000 PM -05:00
SYSTEM               OPEN                                        17-SEP-20 06.12.43.000000000 AM -05:00

43 rows selected.

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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Output of SQL command to find last successful login date using DBA_AUDIT_TRAIL

LAST_LOGIN        USERNAME
----------------- ---------------
04:32:57 18/11/20 TEST11
04:31:43 18/11/20 TEST12
04:27:19 18/11/20 DBSNMP
04:10:26 18/11/20 TEST13
SQL>
$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$