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
2 months 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
2 months 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
Monroe
1 months ago
User 3: I'll go with 16 kB as well, better safe than sorry.
upvoted 0 times
...
Barabara
1 months ago
User 2: Yeah, I think 16 kB should be sufficient.
upvoted 0 times
...
Gladys
1 months ago
User 1: I agree, 24 kB seems like too much.
upvoted 0 times
...
...
Tracey
2 months ago
I agree with Heike, a larger block size can help prevent log entries from being misaligned.
upvoted 0 times
...
Heike
2 months 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
2 months ago
I disagree, I believe it should be set to 8 kB.
upvoted 0 times
...
Kendra
2 months 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
2 months 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
Clorinda
1 months ago
I've always set mine to 4 kB and haven't had any issues with misalignment.
upvoted 0 times
...
Millie
1 months ago
I think 8 kB might also work well to prevent misaligned log entries.
upvoted 0 times
...
Joaquin
2 months ago
I agree, 16 kB is the recommended size for Oracle Redo Log blocks.
upvoted 0 times
...
...
Heike
2 months ago
I think the Oracle Redo Log block size should be set to 16 kB.
upvoted 0 times
...

Save Cancel