The time and cpu time values seem lower
Chapter 15 ■ Optimize DistributeD WOrklOaD
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
12 rows selected.
515
FIPS SCDB_2 60317 23490 60317 79.88 SCDB_3 46358 12926 46358 105.18 SCDB_4 52800 13701 52800 44.31 SCDB_5 54303 13607 54303 71.31
In the preceding output, service TAPS on both instances does not seem balanced. The service time on SCDB_2 is high, the overall throughput is low; however, the DB time and CPU time values seem lower. When a message is received by the application server using the FAN technology regarding the current state of the instance, new sessions will be directed by FAN to instance SCDB_2.