creating a profile with the time period for locking the account:
CREATE PROFILE test_profile LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LOCK_TIME UNLIMITED