How to Efficiently Manage User Lockout: Redis Cache vs Database Storage

This article examines the design choices for handling a member's lockout state after multiple failed logins, comparing Redis cache storage with a database field, and proposes a refactoring plan that balances performance, consistency, and operational complexity.

BackendJavaOracle

0 likes · 5 min read

How to Efficiently Manage User Lockout: Redis Cache vs Database Storage

ITPUB

Mar 28, 2016 · Databases

Why Did My Oracle User Keep Getting Locked? A Step‑by‑Step Investigation

A colleague changed an Oracle application user's password, only to see the account lock every few minutes; the article walks through checking the database version, profile settings, listener logs, discovering a lingering dataSync.jar process that still used the old password, and outlines remediation steps.

Listener LogOracleRAC

0 likes · 10 min read

Why Did My Oracle User Keep Getting Locked? A Step‑by‑Step Investigation