Oracle database tips&tricks

Here I am going to collect useful queries for Oracle database.

If you use many database users and need to check which of them are locked:

select username, ACCOUNT_STATUS from dba_users where username in ('DB_USER1', 'DB_USER2', 'DB_USER3', ....);

User with EXPIRED or LOCKED status can reactivated back to OPEN status by:

alter user DB_USER1 account unlock;

To prevent account expiration in future - you can set unlimited password time frame for all users with default profile:

alter profile default limit password_life_time_unlimited;