Database Networking (MOSC)

MOSC Banner

puzzling with goal and clb_goal in dbms_service.create_service

edited Aug 3, 2009 10:06AM in Database Networking (MOSC) 3 commentsAnswered

DBMS_SERVICE.CREATE_SERVICE(
service_name IN VARCHAR2,
network_name IN VARCHAR2,
goal IN NUMBER DEFAULT NULL,
dtp IN BOOLEAN DEFAULT NULL,
aq_ha_notifications IN BOOLEAN DEFAULT NULL,
failover_method IN VARCHAR2 DEFAULT NULL,
failover_type IN VARCHAR2 DEFAULT NULL,
failover_retries IN NUMBER DEFAULT NULL,
failover_delay IN NUMBER DEFAULT NULL,
clb_goal IN NUMBER DEFAULT NULL);

From oracle's doc: "goal" stands for workload management goal for the service and "clb_goal" stands for connect load balancing goal for the service.

It seems both can decide which instance to connect for a client request so I think they are very similar.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center