Optimize Distributed Workload - Expert Oracle RAC Performance Diagnostics and Tuning - page 505

SQL>
INST NAME GOAL CLB_G AQ_
---- -------------------- ------------ ----- ---
2 FIPS THROUGHPUT SHORT YES
2 TAPS THROUGHPUT SHORT YES
2 SCDBXDB NONE LONG NO
2 SCDB NONE LONG NO
2 SYS$BACKGROUND NONE SHORT NO
2 SYS$USERS NONE SHORT NO
1 FIPS THROUGHPUT SHORT YES
1 TAPS THROUGHPUT SHORT YES
1 SCDBXDB NONE LONG NO
1 SCDB NONE LONG NO
1 SYS$BACKGROUND NONE SHORT NO
1 SYS$USERS NONE SHORT NO
The preceding output service TAPS has not been configured for run time load balancing, and the connection time
load-balancing option defined is SHORT . Using the following procedure, the run time load-balancing goal is changed
to THROUGHPUT :
srvctl modify service -d SPDB -s TAPS -j SHORT -B THROUGHPUT
The following new output from the GV$ACTIVE_SERVICES view illustrates this change. This can also be viewed
from V$SERIVCES :
SQL> COL inst format 999
COL name format a20
SELECT inst_id INST,
name,
network_name,
goal,
blocked,
aq_ha_notification AQ,
clb_goal
FROM gv$active_services;
SQL>
INST NAME NETWORK_NA GOAL BLO AQ CLB_G
---- -------------------- ---------- ------------ --- --- -----
2 FIPS FIPS THROUGHPUT NO YES SHORT
2 TAPS TAPS THROUGHPUT NO YES SHORT
2 SCDBXDB SCDBXDB NONE NO NO LONG
2 SCDB SCDB NONE NO NO LONG
2 SYS$BACKGROUND NONE NO NO SHORT
2 SYS$USERS NONE NO NO SHORT
1 FIPS FIPS THROUGHPUT NO YES SHORT
1 TAPS TAPS THROUGHPUT NO YES SHORT
1 SCDBXDB SCDBXDB NONE NO NO LONG
1 SCDB SCDB NONE NO NO LONG
1 SYS$BACKGROUND NONE NO NO SHORT
1 SYS$USERS NONE NO NO SHORT
12 rows selected.