audit_file_dest                      string                           C:\ORACLE\ORA12C\HOME\DBS\ADMIN\ADUMP
audit_sys_operations                 boolean                          TRUE
audit_trail                          string                           DB

select
    os_username,
   username,
   userhost,terminal client,
   action_name,
   returncode,timestamp
from
      dba_audit_session
      where
      returncode='1017'
      and
      username=='<username>'
      order by timestamp desc

select terminal,userhost,spare1,ntimestamp# from aud$
where
returncode='1017'
and
userid='<username>'
order by ntimestamp# desc

username=='<username>'

select username,
       account_status,
       lock_date,
       expiry_date,
       profile
from dba_users
where username='<USER IN QUESTION IN CAPS'
;

SQL> select username,
  2  account_status,
  3  lock_date,
  4  expiry_date,
  5  profile
  6  from dba_users
  7  where username='SCOTT';

USERNAME		       ACCOUNT_STATUS			LOCK_DATE
------------------------------ -------------------------------- ---------
EXPIRY_DA PROFILE
--------- ------------------------------
SCOTT			       OPEN
18-APR-19 DEFAULT