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; 原文链接：https://www.f2er.com/oracle/211565.html