Object Storage Sizing
One particularly important task for the DBA is to properly size the storage of objects in the database. This sizing primarily deals with the number and size of extents occupied. There is a widely held myth that multiple extents have a negative effect on performance; however, this is not necessarily the case. In fact, multiple extents, when properly planned and sized in a Parallel Query environment, can dramatically improve the overall performance of the database.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
