DESC DBA_USERS; SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,LOCK_DATE FROM DBA_USERS WHERE ACCOUNT_STATUS LIKE 'LOCKED' ORDER BY LOCK_DATE,USERNAME;