In your four-node RAC cluster, there are three services for three different workload types. Each has correct preferred and available instances configured in the clusterware.
There is an OLTP workload where 1,000 users connect and remain connected all day doing short transactions, and connections should be balanced across all four instances.
There is a BATCH service where the code is long-running and CPU-intensive, the number of batch processes vary by day of week, and connections use two of the four instances.
Finally, there is a DSS service where up to 25 users log in for ad hoc DSS queries, and connections are balanced on the two non-batch instances and should use the least amount of time.
Which configuration would you recommend as the best for GOAL and CLB_GOAL using DBMS_SERVICE as well as for client-side load balancing?
A.
Client-side load balancing for OLTP only. For OLTP, set CLB_GOAL to SHORT and GOAL to NONE. For BATCH, set CLB_GOAL to LONG and GOAL to NONE. For DSS, set CLB_GOAL to SHORT and GOAL to GOAL_SERVICE_TIME.
B.
Client-side load balancing for all three services. For OLTP, set CLB_GOAL to LONG and GOAL to NONE.
For BATCH, set CLB_GOAL to SHORT and GOAL to NONE. For DSS, set CLB_GOAL to SHORT and GOAL to GOAL_SERVICE_TIME.
C.
Client-side load balancing for all three services. For OLTP, set CLB_GOAL to SHORT and GOAL to NONE. For BATCH, set CLB_GOAL to LONG and GOAL to NONE. For DSS, set CLB_GOAL to SHORT and GOAL to GOAL_SERVICE_TIME.