oracle 9I:
数据库用户登陆10次以上用户不被锁，且在user$视图里的登陆错误信息也没有
SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied

SQL>  select name,lcount
  2  from user$
  3  where name='HR';

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL>

oracle 10G:
数据库用户登陆10次以上用户被锁，且在user$视图里的登陆错误信息被记录

SQL> conn bdi/bdi
Connected.
SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn bdi/890
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> conn bdi/12
ERROR:
ORA-28000: the account is locked

SQL> select name,lcount
  2  from user$
  3  where name='BDI';

NAME                               LCOUNT
------------------------------ ----------
BDI                                     0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                     1

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                     2

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                    10

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                    10

SQL>

SQL> alter user bdi accouont unlock;
SP2-0640: Not connected
SQL> conn / as sysdba
Connected.
SQL> alter user bdi account unlock;

User altered.

SQL>

在这里我终于明白了一件事情，好几次开发来找我说是数据库连不上，我一用户连数据库，就报数据库用户被锁了，
原来是开发把密码搞错了，输入错误密码超过10次以上oracle就会自动的把用户锁掉，下次开发的来找可有话说了