Oracle 11g Users

sqlplus / as sysdba on console

tables:
dba_users - all users from database
user_users - all users from schema

all_users - list users plus users having access to schema

desc dba_users;

select username, account_status, lock_date from dba_users;