Check Oracle user account lock status

Use the following script to verify an oracle user lock status.

select username, account_status, created, lock_date, expiry_date from dba_users
where username = 'XXX12345';

The response

USERNAME	ACCOUNT_STATUS	CREATED	LOCK_DATE	EXPIRY_DATE
XXX12345	LOCKED(TIMED)	03/03/2017 13:36:24	06/12/2018 08:10:54	NULL