Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam 1z0-068 topic 1 question 38 discussion

Actual exam question from Oracle's 1z0-068
Question #: 38
Topic #: 1
[All 1z0-068 Questions]

Which three options have a RAC-specific tuning component?

  • A. contention on index leaf blocks
  • B. sequence definitions
  • C. the size of the online redo log buffers
  • D. contention for online redo log files
  • E. contention for archived redo log files
  • F. the load on the Cluster Interconnect
Show Suggested Answer Hide Answer
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

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Yoones
2 years, 5 months ago
ABF is correct.
upvoted 3 times
...
FTR72
3 years, 4 months ago
ABF, sequence tuning is important in RAC
upvoted 1 times
rodriguesJC
1 year, 7 months ago
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
...
...
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.

SaveCancel
Loading ...