DescriptionGEnCache is a Rdb tool which generate the SQL statement for create a cache on a table or index stored in a uniform storage area.It also generate a report on the distribution of the record size. Example$ gencache db tblAnalyze tbl 89 - 92 : 7 7 93 - 96 : 375 382 97 - 100 : 1408 1790 101 - 104 : 2834 4624 105 - 108 : 1900 6524 109 - 112 : 1254 7778 113 - 116 : 1600 9378 117 - 120 : 1908 11286 121 - 124 : 2505 13791 125 - 128 : 309 14100 129 - 132 : 115 14215 133 - 136 : 81 14296 137 - 140 : 107 14403 141 - 144 : 62 14465 145 - 148 : 61 14526 149 - 152 : 58 14584 153 - 156 : 69 14653 157 - 160 : 84 14737 161 - 164 : 93 14830 165 - 168 : 70 14900 169 - 172 : 46 14946 173 - 176 : 33 14979 alter database filename db add cache tbl row len is 176 bytes cache size is 14979 rows -- 8192, 16384 row replacement is enabled number of reserved rows is 20 large memory is enable shared memory is system window count is 10 allocation is 50000 blocks extent is 20000 blocks ; Downloadgencache.zip |
|
|