You are here

Groesse einer Informix -Tabelle ermitteln

 

rf03@informix[rf03]: oncheck -pt d100p:trppot|more

 

TBLspace Report for d100p:dvauser.trppot
 
    Physical Address               2:441282
    Creation date                  06/12/2007 13:26:20
    TBLspace Flags                 80880a     Row Locking
                                              TBLspace flagged for replication
                                              TBLspace use 4 bit bit-maps
    Maximum row size               76       
    Number of special columns      0        
    Number of keys                 0        
    Number of extents              21       
    Current serial value           1        
    Pagesize (k)                   4        
    First extent size              8192     
    Next extent size               8192     
    Number of pages allocated      397312            397312 * 4 k = 1589248 ~ 1552MB
    Number of pages used           397312   
    Number of data pages           353501   
    Number of rows                 19791621 
    Partition partnum              2097394  
    Partition lockid               2097394  
 
    Extents                      
         Logical Page     Physical Page        Size Physical Pages
                    0          2:465866        8192       8192
                 8192         2:7259938       81920      81920
                90112         2:7343946       40960      40960
               131072         2:7386793       32768      32768
               163840         2:7423658       32768      32768
               196608         2:7458474        8192       8192
               204800         2:7467690       32768      32768
               237568         2:7502506       36864      36864
               274432         2:7542954       40960      40960
               315392         3:1914719        4096       4096
               319488         3:1991903        4096       4096
               323584         3:2000095        8192       8192