New Features for Administrators - Question 028

For the best performance, what should be done with blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database?

A. They should be transferred across a high-speed cluster interconnect.

B. They should be written to disk by the sending instance and read from disk by the receiving instance.

C. They should be granted, by the Global Cache Service, an exclusive mode resource for each instance involved.

D. They should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered.

Answer: A

Explanation:

The blocks transferred using the Cache Fusion algorithm in a Real Application Clusters database should be transferred across a high-speed cluster interconnect to increase the performance.

Incorrect Answers

B: They should not be written to disk by the sending instance and read from disk by the receiving instance. Cache Fusion algorithm does not use disk read/write operations to transfer blocks.

C: It’s not possible to grant by the Global Cache Service an exclusive mode resource for EACH instance involved. Only one instance can have exclusive mode.

D: It’s not required that these blocks should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 223-230

Chapter 4: Performance and Scalability Enhancements

Oracle 9i New Features, Robert Freeman, p. 193-206

Chapter 7: Oracle9i Real Application Clusters