How to check if a user is locked in Oracle?

To check if a user is locked in an Oracle database, you can follow these steps:

1. Connect to the database as sysdba.

sqlplus / as sysdba

1. Use the following SQL query to check the status of a user:

SELECT username, account_status
FROM dba_users
WHERE username = '要查询的用户名';

Please replace ‘要查询的用户名’ with the actual username you want to search for.

This query will return a result set containing the username and account status. If the user is locked, the account_status column will display ‘LOCKED’.

Please note that this query may not be executed if the user you are looking for does not exist or if you do not have sufficient permissions to query the dba_users view.