Checking Table space utilization: oncheck -pT database:table

Output from oncheck -pT to print table space utilization

lester@merlin >oncheck -pT stores7:items

TBLspace Report for stores7:lester.items

Physical Address 119fca

Creation date 07/04/97 17:34:08

TBLspace Flags 801 Page Locking

TBLspace use 4 bit bit-maps

Maximum row size 18

Number of special columns 0

Number of keys 3

Number of extents 1

Current serial value 1

First extent size 8

Next extent size 8

Number of pages allocated 8

Number of pages used 5

Number of data pages 1

Number of rows 67

Partition partnum 1048769

Partition lockid 1048769

Previous slide

Next slide

Back to first slide

View graphic version