[next] [previous] [contents]

  DBAMNU Parameters PAG_SIZ

  You may specify the minimum size of a database page.
  The value must be an integer between 1 and 63.

  It is recommended that the buffer size be a multiple of the
  minimum page size. Where different page sizes are or may
  be used, the buffer size should be a multiple of each page size.
  As a result, the following page size sets are suggested:

  Minimum Page
  Size Buffer Size Page Sizes


  2 2 2
  2 4 2, 4
  2 6 2, 3, 6
  2 8 2, 4, 8
  2 10 2, 5, 10
  2 12 2, 3, 4, 6, 12
  2 14 2, 7, 14
  2 16 2, 4, 8, 16
  2 18 2, 3, 6, 9, 18
  2 20 2, 4, 5, 10, 20
  2 22 2, 11, 22
  2 24 2, 3, 4, 6, 8, 12, 24
  2 26 2, 13, 26
  2 28 2, 4, 7, 14, 28
  2 30 2, 3, 5, 6, 10, 15, 30
  2 32 2, 4, 8, 16, 32
  2 34 2, 17, 34
  2 36 2, 3, 4, 6, 9, 12, 18, 36
  2 38 2, 19, 38
  2 40 2, 4, 5, 8, 10, 20, 40
  2 42 2, 3, 6, 7, 14, 21, 42
  2 44 2, 4, 11, 22, 44
  2 46 2, 23, 46
  2 48 2, 3, 4, 6, 8, 12, 16, 24, 48
  2 50 2, 5, 10, 25, 50
  2 52 2, 4, 13, 26, 52
  2 54 2, 3, 6, 9, 18, 27, 54
  2 56 2, 4, 7, 8, 14, 28, 56
  2 58 2, 29, 58
  2 60 2, 3, 4, 5, 6, 10, 12, 15, 20, 30, 60
  2 62 2, 31, 62
  3 3 3
  3 6 3, 6
  3 9 3, 9
  3 12 3, 4, 6, 12
  3 15 3, 5, 15
  3 18 3, 6, 9, 18
  3 21 3, 7, 21
  3 24 3, 4, 6, 8, 12, 24
  3 27 3, 9, 27
  3 30 3, 5, 6, 10, 15, 30
  3 33 3, 11, 33
  3 36 3, 4, 6, 9, 12, 18, 36
  3 39 3, 13, 39
  3 42 3, 6, 7, 14, 21, 42
  3 45 3, 5, 9, 15, 45
  3 48 3, 4, 6, 8, 12, 16, 24, 48
  3 51 3, 17, 51
  3 54 3, 6, 9, 18, 27, 54
  3 57 3, 19, 57
  3 60 3, 4, 5, 6, 10, 12, 15, 20, 30, 60
  3 63 3, 7, 9, 21, 63
  4 4 4
  4 8 4, 8
  4 12 4, 6, 12
  4 16 4, 8, 16
  4 20 4, 5, 10, 20
  4 24 4, 6, 8, 12, 24
  4 28 4, 7, 14, 28
  4 32 4, 8, 16, 32
  4 36 4, 6, 9, 12, 18, 36
  4 40 4, 5, 8, 10, 20, 40
  4 44 4, 11, 22, 44
  4 48 4, 6, 8, 12, 16, 24, 48
  4 52 4, 13, 26, 52
  4 56 4, 7, 8, 14, 28, 56
  4 60 4, 5, 6, 10, 12, 15, 20, 30, 60
  5 5 5
  5 10 5, 10
  5 15 5, 15
  5 20 5, 10, 20
  5 25 5, 25
  5 30 5, 6, 10, 15, 30
  5 35 5, 7, 35
  5 40 5, 8, 10, 20, 40
  5 45 5, 9, 15, 45
  5 50 5, 10, 25, 50
  5 55 5, 11, 55
  5 60 5, 6, 10, 12, 15, 20, 30, 60
  6 6 6
  6 12 6, 12
  6 18 6, 9, 18
  6 24 6, 8, 12, 24
  6 30 6, 10, 15, 30
  6 36 6, 9, 12, 18, 36
  6 42 6, 7, 14, 21, 42
  6 48 6, 8, 12, 16, 24, 48
  6 54 6, 9, 18, 27, 54
  6 60 6, 10, 12, 15, 20, 30, 60
  7 7 7
  7 14 7, 14
  7 21 7, 21
  7 28 7, 14, 28
  7 35 7, 35
  7 42 7, 14, 21, 42
  7 49 7, 49
  7 56 7, 8, 14, 28, 56
  7 63 7, 9, 21, 63
  8 8 8
  8 16 8, 16
  8 24 8, 12, 24
  8 32 8, 16, 32
  8 40 8, 10, 20, 40
  8 48 8, 12, 16, 24, 48
  8 56 8, 14, 28, 56
  9 9 9
  9 18 9, 18
  9 27 9, 27
  9 36 9, 12, 18, 36
  9 45 9, 15, 45
  9 54 9, 18, 27, 54
  9 63 9, 21, 63
  10 10 10
  10 20 10, 20
  10 30 10, 15, 30
  10 40 10, 20, 40
  10 50 10, 25, 50
  10 60 10, 12, 15, 20, 30, 60
  11 11 11
  11 22 11, 22
  11 33 11, 33
  11 44 11, 22, 44
  11 55 11, 55
  12 12 12
  12 24 12, 24
  12 36 12, 18, 36
  12 48 12, 16, 24, 48
  12 60 12, 15, 20, 30, 60
  13 13 13
  13 26 13, 26
  13 39 13, 39
  13 52 13, 26, 52
  14 14 14
  14 28 14, 28
  14 42 14, 21, 42
  14 56 14, 28, 56
  15 15 15
  15 30 15, 30
  15 45 15, 45
  15 60 15, 20, 30, 60
  16 16 16
  16 32 16, 32
  16 48 16, 24, 48
  17 17 17
  17 34 17, 34
  17 51 17, 51
  18 18 18
  18 36 18, 36
  18 54 18, 27, 54
  19 19 19
  19 38 19, 38
  19 57 19, 57
  20 20 20
  20 40 20, 40
  20 60 20, 30, 60
  21 21 21
  21 42 21, 42
  21 63 21, 63
  22 22 22
  22 44 22, 44
  23 23 23
  23 46 23, 46
  24 24 24
  24 48 24, 48
  25 25 25
  25 50 25, 50
  26 26 26
  26 52 26, 52
  27 27 27
  27 54 27, 54
  28 28 28
  28 56 28, 56
  29 29 29
  29 58 29, 58
  30 30 30
  30 60 30, 60
  31 31 31
  31 62 31, 62

  Note that for page sizes of between 32 and 63 blocks the
  buffer size should be the same size as the page size.

  Buffer Size Page Sizes


  1 1
  2 1, 2
  3 1, 3
  4 1, 2, 4
  5 1, 5
  6 1, 2, 3, 6
  7 1, 7
  8 1, 2, 4, 8
  9 1, 3, 9
  10 1, 2, 5, 10
  11 1, 11
  12 1, 2, 3, 4, 6, 12
  13 1, 13
  14 1, 2, 7, 14
  15 1, 3, 5, 15
  16 1, 2, 4, 8, 16
  17 1, 17
  18 1, 2, 3, 6, 9, 18
  19 1, 19
  20 1, 2, 4, 5, 10, 20
  21 1, 3, 7, 21
  22 1, 2, 11, 22
  23 1, 23
  24 1, 2, 3, 4, 6, 8, 12, 24
  25 1, 5, 25
  26 1, 2, 13, 26
  27 1, 3, 9, 27
  28 1, 2, 4, 7, 14, 28
  29 1, 29
  30 1, 2, 3, 5, 6, 10, 15, 30
  31 1, 31
  32 1, 2, 4, 8, 16, 32
  33 1, 3, 11, 33
  34 1, 2, 17, 34
  35 1, 5, 7, 35
  36 1, 2, 3, 4, 6, 9, 12, 18, 36
  37 1, 37
  38 1, 2, 19, 38
  39 1, 3, 13, 39
  40 1, 2, 4, 5, 8, 10, 20, 40
  41 1, 41
  42 1, 2, 3, 6, 7, 14, 21, 42
  43 1, 43
  44 1, 2, 4, 11, 22, 44
  45 1, 3, 5, 9, 15, 45
  46 1, 2, 23, 46
  47 1, 47
  48 1, 2, 3, 4, 6, 8, 12, 16, 24, 48
  49 1, 7, 49
  50 1, 2, 5, 10, 25, 50
  51 1, 3, 17, 51
  52 1, 2, 4, 13, 26, 52
  53 1, 53
  54 1, 2, 3, 6, 9, 18, 27, 54
  55 1, 5, 11, 55
  56 1, 2, 4, 7, 8, 14, 28, 56
  57 1, 3, 19, 57
  58 1, 2, 29, 58
  59 1, 59
  60 1, 2, 3, 4, 5, 6, 10, 12, 15, 20, 30, 60
  61 1, 61
  62 1, 2, 31, 62
  63 1, 3, 7, 9, 21, 63