Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Dell EMC Exam D-XTR-DS-A-24 Topic 3 Question 21 Discussion

Actual exam question for Dell EMC's D-XTR-DS-A-24 exam
Question #: 21
Topic #: 3
[All D-XTR-DS-A-24 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

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.


by Malcom at Mar 24, 2025, 07:09 AM

Limited Time Offer

25%

Off

Get Premium D-XTR-DS-A-24 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Helga
4 days ago
I bet the Oracle developers were having a laugh when they came up with these answer choices. 'Let's throw in a 24 kB option, just to see who's paying attention!'
upvoted 0 times
...
Herminia
7 days ago
24 kB? That's a bit overkill, don't you think? I'll go with the good ol' 16 kB for this one.
upvoted 0 times
...
Tracey
7 days ago
I agree with Heike, a larger block size can help prevent log entries from being misaligned.
upvoted 0 times
...
Heike
10 days ago
But a larger block size like 16 kB can reduce the number of read-modify-write operations and improve performance.
upvoted 0 times
...
Isaac
11 days ago
I disagree, I believe it should be set to 8 kB.
upvoted 0 times
...
Kendra
11 days ago
Hmm, 8 kB seems a bit small for the redo log block size. Wouldn't that increase the chance of misalignment?
upvoted 0 times
...
Shenika
12 days ago
I think 16 kB is the best option to prevent misaligned log entries. That's what I learned in my Oracle training.
upvoted 0 times
...
Heike
13 days ago
I think the Oracle Redo Log block size should be set to 16 kB.
upvoted 0 times
...

Save Cancel