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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset