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;