![[ Informix Logo ]](/_borders/inflogo1.gif) |
Архив интересных статей по Informix |
TABLE UNWANTED FRAGMENTATION
>I'm afraid there isn't much you can do about the extents on the system
>catalogs. I wish there were. It shouldn't affect performance TOO much,
>because the catalogs are typically being cached anyway.
>
>As for the temporary dbspace, you may consider dropping and readding it.
>There aren't any tables in it now, because all of the tables are temporary
>and go away. However, it looks like at some point you either had a very
>large temp table or lots of concurrent temp tables.
>
>HTH,
>
>- Tom Girsch
>
>BEATRIZ ROCHA <BEATRICE.ROCHA@worldnet.att.net> wrote in message
>news:01be8610$cb5e34a0$ca924d0c@camila...
>> I did an oncheck -pe and I get the following on the temporary db space.
>Is
>> this normal. Why is the temporary db space fragmented if there are no
>> tables in it? Is this affecting performance?
>>
>>
>> Chunk: 12 /informix/symlinks/tempdbs1 Size Used
>> Free
>> 500000 4803
>495197
>>
>> Disk usage for Chunk 12 Start Length
>> ------------------------------------------- --------- ---------
>> OTHER RESERVED Pages 0 2
>> CHUNK FREE LIST PAGE 2 1
>> TBLSPACE TBLSPACE 3 50
>> FREE 53 992
>> TBLSPACE TBLSPACE 1045 50
>> FREE 1095 2144
>> TBLSPACE TBLSPACE 3239 50
>> FREE 3289 1600
>> TBLSPACE TBLSPACE 4889 50
>> FREE 4939 1600
>> TBLSPACE TBLSPACE 6539 50
>> FREE 6589 1600
>> TBLSPACE TBLSPACE 8189 50
>> FREE 8239 1600
>> TBLSPACE TBLSPACE 9839 50
>> FREE 9889 1600
>> TBLSPACE TBLSPACE 11489 50
>> FREE 11539 1600
>> TBLSPACE TBLSPACE 13139 50
>> FREE 13189 1600
>> TBLSPACE TBLSPACE 14789 50
>> FREE 14839 1600
>> TBLSPACE TBLSPACE 16439 50
>> FREE 16489 1600
>> TBLSPACE TBLSPACE 18089 50
>> FREE 18139 1600
>> TBLSPACE TBLSPACE 19739 50
>> FREE 19789 1600
>> TBLSPACE TBLSPACE 21389 50
>> FREE 21439 1600
>> TBLSPACE TBLSPACE 23039 50
>> FREE 23089 1600
>> TBLSPACE TBLSPACE 24689 50
>> FREE 24739 1600
>> TBLSPACE TBLSPACE 26339 100
>> FREE 26439 3200
>> TBLSPACE TBLSPACE 29639 100
>> FREE 29739 3200
>> TBLSPACE TBLSPACE 32939 100
>> FREE 33039 3200
>> TBLSPACE TBLSPACE 36239 100
>> FREE 36339 3200
>> TBLSPACE TBLSPACE 39539 100
>> FREE 39639 3200
>> TBLSPACE TBLSPACE 42839 100
>> FREE 42939 3200
>> TBLSPACE TBLSPACE 46139 100
>> FREE 46239 3200
>> TBLSPACE TBLSPACE 49439 100
>> FREE 49539 3200
>> TBLSPACE TBLSPACE 52739 100
>> FREE 52839 3200
>> TBLSPACE TBLSPACE 56039 100
>> FREE 56139 3200
>> TBLSPACE TBLSPACE 59339 100
>>
>>
>>
>>
>>
>>
>> I have one more question. I am re-creating a table so it does not get too
>> fragmented over time. The only problem that I have is that the informix
>> tables containing the statistics are in the same dbspace. Should I drop
>> the sys tables for the statistics, re-create the table and update
>> statistics again?
>> (The temp table will not be there in production)
>> THANKS
>>
>>
>> DBspace Usage Report: dbspace1 Owner: informix Created:
>> 11/09/98
>>
>> Chunk: 2 /informix/symlinks/a1_1 Size Used
>> Free
>> 1000000 655503
>344497
>>
>> Disk usage for Chunk 2 Start Length
>> ------------------------------------------- --------- ---------
>> OTHER RESERVED Pages 0 2
>> CHUNK FREE LIST PAGE 2 1
>> TBLSPACE TBLSPACE 3 50
>> zg_sales:informix.systables 53 8
>> zg_sales:informix.syscolumns 61 16
>> zg_sales:informix.sysindexes 77 8
>> zg_sales:informix.systabauth 85 8
>> zg_sales:informix.syscolauth 93 8
>> zg_sales:informix.sysviews 101 8
>> zg_sales:informix.sysusers 109 8
>> zg_sales:informix.sysdepend 117 8
>> zg_sales:informix.syssynonyms 125 8
>> zg_sales:informix.syssyntable 133 8
>> zg_sales:informix.sysconstraints 141 8
>> zg_sales:informix.sysreferences 149 8
>> zg_sales:informix.syschecks 157 8
>> zg_sales:informix.sysdefaults 165 8
>> zg_sales:informix.syscoldepend 173 8
>> zg_sales:informix.sysprocedures 181 8
>> zg_sales:informix.sysprocbody 189 8
>> zg_sales:informix.sysprocplan 197 8
>> zg_sales:informix.sysprocauth 205 8
>> zg_sales:informix.sysblobs 213 8
>> zg_sales:informix.sysopclstr 221 8
>> zg_sales:informix.systriggers 229 8
>> zg_sales:informix.systrigbody 237 8
>> zg_sales:informix.sysdistrib 245 8
>> zg_sales:informix.sysfragments 253 8
>> zg_sales:informix.sysfragauth 261 8
>> zg_sales:informix.sysroleauth 269 8
>> zg_sales:informix.sysobjstate 277 8
>> zg_sales:informix.sysviolations 285 8
>> zg_sales:informix.sysprocbody 293 8
>> zg_sales:zg_sales.sales 301 756
>> zg_sales:informix.sysdistrib 1057 8
>> FREE 1065 4
>> zg_sales:informix.sysindexes 1069 8
>> zg_sales:zg_sales.sales 1077 277250
>> FREE 278327 6
>> zg_sales:informix.sysdistrib 278333 24
>> zg_sales:zg_sales.sales 278357 288250
>> zg_sales:zg_sales.test_table 566607 8
>> zg_sales:informix.sysdistrib 566615 8
>> FREE 566623 32
>> zg_sales:informix.sysdistrib 566655 8
>> FREE 566663 20
>> zg_sales:informix.sysdistrib 566683 32
>> zg_sales:zg_sales.sales 566715 88850
>> FREE 655565 344435
>>
>>
>>
>> --
>> Regards,
>> Beatriz Rocha
>> beatrice.rocha@worldnet.att.net
>
>
| [ Home ] |
Сайт создан при поддержке Украинского
представительства Informix Software Inc. |
Hosted by ANTEC |