课程第9次（2017-03-13星期一）

botang

上完1Z0-052第6章：网络
1Z0-051共12章（上完0章），1Z0-052共19章（上完3章），1Z0-053共21章（上完0章）
总共上完全部52章中的3章

1. select  * from v_$dispatcher  d
   
2. where d.PADDR =(select c.DISPATCHER  from v_$circuit  c);
   
3. 
   
4. select  s.SQL_HASH_VALUE, s.SQL_ID  from v_$session s
   
5. where s.SADDR  in (select    c.SADDR  from v_$circuit c)
   
6. and s.USERNAME='SH' ;
   
7. 
   
8. select  * from v_$sql  s  where s.SQL_ID='99b5r5nhrwjkg';
   
9. 
   
10. grant create database link to hr;
    
11. 
    
12. ---
    
13. create database link dblink1
    
14. connect to hr identified by hr
    
15. using 'orcl199';
    
16. 
    
17. select  salary from employees@dblink1 where employee_id=100;
    
18. 
    
19. update employees@dblink1 set salary=50000 where employee_id=100;
    
20. 
    
21.   create database link dblink2
    
22. connect to hr identified by hr
    
23. using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))  (CONNECT_DATA =
    
24.       (SERVER = DEDICATED)      (SERVICE_NAME = utforcl.example.com)    )  )';
    
25.       
    
26.      select  salary from employees@dblink2 where employee_id=100;  

复制代码