SyntaxFix

[oracle] How do I get a list of locked users in an Oracle database? 

select username,
       account_status 
  from dba_users 
 where lock_date is not null;

This will actually give you the list of locked users.

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to system-administration

• How do I extract the contents of an rpm? • How do you uninstall the package manager "pip", if installed from source? • How do I get a list of locked users in an Oracle database? • What Process is using all of my disk IO • Map a network drive to be used by a service

Examples related to locked

• OperationalError: database is locked • How do I get a list of locked users in an Oracle database?