Oracle detect invalid password

-- Detects invalid password fails (ORA-01017)
SELECT username,
       os_username,
       userhost,
       client_id,
       trunc(timestamp),
       count(*) as failed_logins
FROM dba_audit_trail
WHERE returncode = 1017
  AND --1017 is invalid username/password
    timestamp > sysdate - 30
GROUP BY username, os_username, userhost, client_id, trunc(timestamp);

Similar codes

0 vote135 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote152 views1 answer
Sql on-premises
SQL
3 votes170 views1 answer
Sql select second max
SQL
0 vote146 views1 answer
Oracle get running queries
SQL
0 vote144 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote110 views1 answer
Oracle sql replace string in clob
SQL
0 vote161 views1 answer
No suitable driver found for sqlite
SQL
0 vote137 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote153 views1 answer
Implicit inner join table alias
SQL
0 vote101 views1 answer
How to connect sql server using ip address in c#
SQL