Friday, June 13, 2008

FAN Service

SQL> exec DBMS_SERVICE.CREATE_SERVICE (service_name => 'FAN_TEST',network_name => 'NW_TEST',aq_ha_notifications => true,failover_method => 'BASIC',failover_type => 'SELECT',failover_retries => 180,failover_delay => 1);

PL/SQL procedure successfully completed.

SQL> exec DBMS_SERVICE.START_SERVICE('FAN_TEST');

PL/SQL procedure successfully completed.

SQL> execute dbms_service.modify_service (service_name => 'FAN_TEST',aq_ha_notifications => true,failover_method  => dbms_service.failover_method_basic, failover_type    => dbms_service.failover_type_select, failover_retries => 300, failover_delay   => 1, goal => dbms_service.goal_service_time, clb_goal => dbms_service.clb_goal_short);

PL/SQL procedure successfully completed.

 

  1  SELECT
  2   TO_CHAR(enq_time, 'HH:MI:SS') Enq_time, user_data
  3   FROM sys.sys$service_metrics_tab
  4   where rownum < 2
  5*  ORDER BY 1
SQL> /

ENQ_TIME
--------
USER_DATA(SRV, PAYLOAD)
--------------------------------------------------------------------------------
01:43:36
SYS$RLBTYP('FAN_TEST', 'VERSION=1.0 database=sdtdb service=FAN_TEST { {instance=
sdtdb1 percent=100 flag=UNKNOWN aff=FALSE} } timestamp=2008-06-13 15:13:36')

  1   SELECT service_id, name,network_name, creation_date
  2* FROM dba_services  where rownum<3
SQL> /

SERVICE_ID NAME
---------- ----------------------------------------------------------------
NETWORK_NAME
--------------------------------------------------------------------------------
CREATION_
---------
         1 SYS$BACKGROUND

20-NOV-07

         2 SYS$USERS

20-NOV-07

SERVICE_ID NAME
---------- ----------------------------------------------------------------
NETWORK_NAME
--------------------------------------------------------------------------------
CREATION_
---------

Parameter Description

service_name : The name of the service limited to 64 characters in the Data Dictionary

network_name : The network name of the service as used in SQLNet connect descriptors for client connections. This is limited to the NET service_names character set (see Oracle Database Net Services Reference).

goal : The workload management goal directive for the service. Valid values:

  • DBMS_SERVICE.GOAL_SERVICE_TIME

  • DBMS_SERVICE.GOAL_THROUGHPUT

  • DBMS_SERVICE.GOAL_NONE

dtp : Declares the service to be for DTP or distributed transactions including XA transactions

aq_ha_notifications : Determines whether HA events are sent via AQ for this service

failover_method : The TAF failover method for the service

failover_type:The TAF failover type for the service

failover_retries:The TAF failover retries for the service

failover_delay :The TAF failover delay for the service

clb_goal: Method used for Connection Load Balancing (see Table 95-2, "Constants used in Connection Balancing Goal Arguments")

No comments:

Post a Comment