Oracle 11g and default 180 day default password life time ( PASSWORD_LIFE_TIME )

SQL> select resource_name,limit from dba_profiles where profile='DEFAULT';
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180



SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;

Profile altered.

SQL> select profile, limit from dba_profiles where resource_name = 'PASSWORD_LIFE_TIME';

PROFILE LIMIT
------------------------------ ----------------------------------------
DEFAULT UNLIMITED
MONITORING_PROFILE DEFAULT

SQL> commit;