查看oracle用户状态

select s.username,s.account_status,s.lock_date,s.expiry_date,s.default_tablespace from dba_users s;