Suggested Answer:ACF🗳️
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. References: http://www.toadworld.com/platforms/oracle/w/wiki/10939.optimizing-oracle-rac#rac-tuning-principles
Sequence tuning is OK, but we have "sequence definition" and i think is about the definition of sequence object, and this is not important in performance.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Yoones
1 year, 3 months agoFTR72
2 years, 2 months agorodriguesJC
5 months ago