Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
the time and cpu time values seem lower

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.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Mehul Shetty

PageId: DOC2871377