altersystemset sec_case_sensitive_logon=false;

show parameter sensitive;

--有效期

ALTERPROFILEDEFAULTLIMITPASSWORD_LIFE_TIMEUNLIMITED;

SELECT*FROM dba_profiles WHEREprofile='DEFAULT'AND resource_name='PASSWORD_LIFE_TIME';