Oracle Exam 1Z0-083 Topic 2 Question 87 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 87
Topic #: 2

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

AData files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

BIf an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

CIf an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

DIf an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

EData files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Show Suggested Answer

Suggested Answer: B, C, D

by Iluminada at Mar 05, 2024, 09:09 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rickie

2 days ago

Wait, so we're supposed to choose two answers? This is getting complicated. I might just guess and hope for the best.

upvoted 0 times

...

Beatriz

7 days ago

I'm not sure about this one. I'll have to look into the differences between synchronous and asynchronous I/O to figure it out.

upvoted 0 times

...

Edelmira

23 days ago

I think C is the correct answer. If the RMAN BACKUP VALIDATE command takes less time than the actual backup, then the write I/O is likely the bottleneck.

upvoted 0 times

Karima

2 days ago

I think C is the correct answer.

upvoted 0 times

...

Dean

27 days ago

I'm not sure about option B. If RMAN BACKUP VALIDATE takes roughly the same time as actual backup, does it really mean read I/O is the bottleneck?

upvoted 0 times

...

Albina

27 days ago

I agree with you, Ardella. Option C also makes sense because if RMAN BACKUP VALIDATE takes less time than actual backup, then write I/O could be the bottleneck.

upvoted 0 times

...

Ardella

30 days ago

I think option A is true because high value in V$BACKUP_ASYNC_IO.SHORT_WAITS indicates a potential performance bottleneck.

upvoted 0 times

...