第36、37和38次： 2014-10-17，2014-10-19

botang

1. select  * from gv$session where  terminal='pts/31';
   
2. 
   
3. select * from dba_services;
   
4. 
   
5. begin
   
6.    dbms_service.modify_service(service_name => 'SEXAMPLE',
   
7.    goal => dbms_service.goal_service_time,aq_ha_notifications => true,
   
8.    failover_method => 'BASIC',failover_type => 'SELECT',
   
9.    failover_retries => 180,failover_delay => 1);
   
10. end;
    
11.    

复制代码