find who is locked the account

SQL> show parameter audit;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /scratch/gbuora/app/gbuora/pro
                                                 duct/11.2.0/dbhome_1/rdbms/aud
                                                 it
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      NONE

Hi,

Please answer to below query.

I want to find out from which server and from which user my database account,let say 'scott' user is getting locked by 3 wrong attempts.

Any query please to find out?

for this query the auditing should be written to database level,for this audit_trail=DB <--it is mandidatory?