ExamGecko
Question list
Search
Search

Question 11 - D-XTR-DS-A-24 discussion

Report
Export

What should the Oracle Redo Log block size be set to in order to prevent log entries from being misaligned by read-modify-write operations for an Oracle database?

A.
16 kB
Answers
A.
16 kB
B.
8 kB
Answers
B.
8 kB
C.
4 kB
Answers
C.
4 kB
D.
24 kB
Answers
D.
24 kB
Suggested answer: B

Explanation:

The Oracle Redo Log block size is recommended to be set to 8 kB. This is based on the best practices for Oracle 19c Database, where it was found that increasing the size of the Oracle redo logs can improve database performance12. However, it's important to note that not every workload will show significant performance increase when increasing the size of the redo logs. Customers should evaluate the AWR to determine if the redo logs have an associated high number and duration of wait times. If the redo logs show a possible bottleneck, then increasing the size of the redo logs could improve performance2.

asked 16/09/2024
Tu Nguyen
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first