Re: 2 gig per raw space

David Williams <djw@smooth1.demon.co.uk> wrote in article <Ek$mCbAl7KIzEw3E@smooth1.demon.co.uk>... > In article <331F9977.613D@inconnect.com>, Thuc Nguyen > <thucn@inconnect.com> writes > ....... > >I understand the extent size method but how can I determine how much I > >need to add to the next size? > > > > Either > > a) Do alter index {indexname} to cluster for an index on the table > > or > > b) unload/reload the table. > > > Then use tbcheck -pe | grep <tablename> to see the size of the table > in pages. > > > Do this 1 weeks apart and take 6 times the difference (i.e. 6 weeks, 3 > months worth of growth). Repeat each month to monitor how fast each > table grows. > ...... You can also run tbcheck -ptT. It will give you detailed disk usage info, including number of pages actually used (the number in systables refers to rows data only, not indices), how much each index is using etc. Also note that OnLine (at least older versions) doesn't like more than 8 extents (it needs an extra read to access them beyond that). -- Dragi Raos 4-MATE Information Engineering (http://www.4mate.hr) Zagreb, Croatia