This preview shows page 1. Sign up to view the full content.
Unformatted text preview: e.
A: Index segments do not cause extensive fragmentation
B: Rollback segments as temporary segments will experience high to very high fragmentation.
This is true in the ROLLBACK tablespace because rollback segments have potentially a very
short lifespan, and Oracle can allocate and deallocate extents as necessitated by long-running
transactions. But lifespan of segments and extents in the TEMPORARY tablespace is much
shorter, so fragmentation for temporary segments are higher.
C: Data segments do not cause big fragmentation
E: Data dictionary segments are not changed very often, they have long lifespan, so they can not
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 354
Chapter 7: Managing the Physical Database Structure
Which data dictionary view shows the available free space in a certain tablespace?
Actualtests.com - The Power of Knowing 1Z0-023 A. DBA_EXTENTS
Answer C is correct....
View Full Document
- Fall '09