Logical Data Storage
The basic unit of storage in ASE is a page. The size of a page before ASE 12.5 was fixed at 2 Kbytes on most platforms, including Solaris. ASE 12.5 builds the master device with the dataserver rather than the buildmaster binary and extends the number of supported page sizes to include 4-, 8-, and 16-Kbyte pages.
Up to 44 bytes at the start of a page are occupied by header data, with pointers to previous and next pages in the page chain and the object ID of the database object the page belongs to, leaving the remaining bytes in the page available for data.
Pages are grouped in units of eight, called extents. Allocation and deallocation of space for tables and indexes is done one page at a time, except for data loads, which ...
Get Configuring and Tuning Databases on the Solaris™ Platform 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.
