5.8 Estimating the size of the data DB area

Use the following formula to determine the data DB area size.

Formula (kilobytes)

data DB area size = DATA_PAGE_NUM × page_size ÷ 1,024

Explanation of variables

DATA_PAGE_NUM: Total number of pages in the data DB area

page_size: Size of the pages in the data DB area (bytes)

For details about DATA_PAGE_NUM, see 5.8.1 Determining the total number of pages in the data DB area.

Organization of this section

• 5.8.1 Determining the total number of pages in the data DB area

• 5.8.2 Determining the number of pages for storing each type of row

• 5.8.3 Determining the number of storage pages for each B-tree index segment

• 5.8.4 Determining the key length (KEYSZ) of a B-tree index

• 5.8.5 Determining the number of storage pages for each text index segment

• 5.8.6 Determining the number of segments for storing each range index

To Page Top