Which three options have a RAC-specific tuning component?

The correct answer is A. contention on index leaf blocks C. the size of the online redo log buffers F. the load on the Cluster Interconnect. A: Contention for data and index blocks in a single instance database will probably magnify in a RAC environment. C: A typical cause of high latencies is when the LMS process must flush uncommitted changes to the redo log prior to sending the block to the requesting instance…

Install and Administer Oracle RAC

Question

Options

Acontention on index leaf blocks
Bsequence definitions
Cthe size of the online redo log buffers
Dcontention for online redo log files
Econtention for archived redo log files
Fthe load on the Cluster Interconnect

How the community answered

(35 responses)

A
71% (25)
B
9% (3)
D
3% (1)
E
17% (6)

Explanation

A: Contention for data and index blocks in a single instance database will probably magnify in a RAC environment. C: A typical cause of high latencies is when the LMS process must flush uncommitted changes to the redo log prior to sending the block to the requesting instance. If the application design is such that uncommitted blocks are often in demand across instances in the cluster then these redo log flushes might become common. F: Examining the interconnect When Global Cache waits are high, we should first determine if the latency is primarily the result of interconnect network waits.

Topics

#cluster interconnect#RAC tuning#index leaf blocks#redo log buffers

Community Discussion

No community discussion yet for this question.

Full 1Z0-068 Practice