Re: Dumb question again

Susan Elliott (ISG) wrote: > > Howdy folks > > Could someone please tell me how to find out the actual size of a > table.. i.e. table fred is 5 gig in size. > I have looked at oncheck - pT, but it really doesn't make a lot of > sense..(2 me) > > Any help would be greatly appreciated. > > Regards > Suze. Here's an example of oncheck -pt <dbsname>:<tabname> TBLspace Report for inv_acct:informix.dba_info Physical Address e00016 Creation date 07/27/97 07:22:28 TBLspace Flags 2 Row Locking Maximum row size 70 Number of special columns 0 Number of keys 2 Number of extents 13 Current serial value 1 First extent size 5000 Next extent size 500 Number of pages allocated 17000 Number of pages used 16639 Number of data pages 14207 Number of rows 383588 Partition partnum 14680083 Partition lockid 14680083 In the above example, number of pages allocated tells you what total space in the dbspace is allocated to table dba_info. Number of pages used tells you how much of that already allocated space is actually used. (And yes, the number of extents tells me to reorg this table ASAP . . . 8-> )