Oracle Password Error Verification delay

Add several password-related issues to note after upgrading from 10g to 11g:

1.11g default start password is case-sensitive, you can set the parameter to Sec_case_sensitive_logon =false Shield

2. The 11g password is valid for 180 days by default and can be modified by modifying ALTER profile default[According to the actual profile] LIMIT password_life_time UNLIMITED; Note need to change password to take effect

3. Password error verification delay, can be set by event= "28401 TRACE NAME CONTEXT FOREVER, Level 1" Shield

Alter system set events= ' 28401 Trace name Context forever, Level 1 ';

If at the same time a large number of connections with the wrong password, basically this user's login will be completely hang.

Database has a large number of library cache lock, and USERNAME all empty SID   USERNAME      event      SCHEMANAME1 &NB Sp              DIAG idle wait SYS2               &NBSP ; ASM Background timer    SYS3                class slave wait   &nbs P     SYS4                class slave wait         SYS 7                library cache lock     SYS8                library cache lock     SYS9                L Ibrary Cache lock     SYS10              library cache lock     SYS              streams aq:waiting for time management or cleanup tasks         &NBSp SYS12              library cache lock     SYS16         & nbsp    library Cache lock     SYS17              space Manager:slave I Dle wait       SYS18              library cache lock     SYS19              library cache lock     SYS21              library Cache lock     SYS

Oracle Password Error verification delay