How to find out if an account has been locked in Oracle 10g

    sqlplus /nolog
    SQL> connect / as sysdba
    SQL> SELECT username, account_status, password FROM dba_users;
Share