Chapter 8: Resource Governor  Chapter 10: User Connections


Chapter 9: Page Allocation for Partitioned DOL Tables

In prior versions of Adaptive Server Enterprise there was a problem where inserts into a partitioned data-only locked table with a placement index may have caused wasted space. The space wastage is more pronounced in tables with a higher number of partitions and also for larger page sizes.

Adaptive Server Enterprise version 12.5.3 avoids wasting extra space by filling up existing allocated extents in the target allocation page even though these extents are assigned to other partitions. The net effect is that we only allocate new extents when there are no free extents in the target allocation page.To turn off the new space allocation mechanism, activate command line trace flag 646 (-T646).





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 10: User Connections

View this book as PDF