第32次：2015-04-09星期四

botang

2015-04-09-a.sql

1. select  * from dba_profiles p where p.resource_type='PASSWORD'  and   p.profile='DEFAULT';
   
2. 
   
3. create profile profile1  limit
   
4. FAILED_LOGIN_ATTEMPTS 1;
   
5. 
   
6. select  * from dba_profiles p where p.resource_type='PASSWORD'  and   p.profile='PROFILE1';
   
7. 
   
8. select  * from dba_users where username='HR';
   
9. 
   
10. alter user hr profile profile1;
    
11. 
    
12. select  * from dba_users where username='HR';
    
13. 
    
14. select  * from dba_profiles p where p.resource_type='PASSWORD'  and   p.profile='PROFILE1';
    
15. 
    
16. alter profile profile1  limit
    
17. PASSWORD_REUSE_TIME  2/1440;
    
18. 
    
19. ----
    
20. 
    
21. 
    
22. 
    
23. alter profile profile1  limit
    
24. password_verify_function verify_function_11g;

复制代码

2015-04-09-b.sql

1. select   BLOCKING_SESSION   from v$session where terminal='pts/8';
   
2. 
   
3. #140 63
   
4. #195 88
   
5. #8 711
   
6. 
   
7. select SID, SERIAL#, USERNAME
   
8.                 from V$SESSION where SID in
   
9.                 (select BLOCKING_SESSION from V$SESSION);
   
10.    
    
11.    
    
12.     select  * from v$session where terminal='pts/6';
    
13.    
    
14.     #140 65
    
15.    
    
16.     select * from v_$lock  l where l.SID=140;
    

复制代码