oracle检查密码过期

select * from dba_profiles where  resource_type='PASSWORD' and  resource_name='PASSWORD_LIFE_TIME'
 select * from dba_profiles where username='SYS' and resource_name='PASSWORD_LIFE_TIME'
 select * from dba_db_links

 SELECT username,PROFILE,expiry_date FROM dba_users;

设置永不过期

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;