The solution to this problem is to recreate the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: t; error. The solution to this problem is to recreate the rollback segment with a higher minimum number of extents, larger extents, or a higher OPTIMAL rollback segment size. You cannot simply increase MAXEXTENTS to resolve this problem. Incorrect Answers: B: Media recovery does not need to be performed because there is no media failure when this error happened. C: Problem with this error can be fixed with a higher minimum number of extents for the rollback segment, not with a higher number of rollback segments. D: Problem with this error can be fixed with larger extents for the rollback segment, not with larger size of rollback segments tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 381 Chapter 8: Managing Database Objects QUESTION 7: When creating rollback segments, what is the recommended value for MINEXTENT minimize dynamic extension? Actualtests.com - The Power of Knowing 1Z0-023 A. 15 B. 20 C. five D. ten per transaction E. number_of_users*25 Answer: B Explanation: Answer B is c...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online