Re: extents of tables
This is for 4 k pages, right?
Jon Myatt <jon@jonners.cix.co.uk> on 11/03/98 05:13:09 AM
Please respond to Jon Myatt <jon@jonners.cix.co.uk>
To: informix-list@iiug.org
cc: (bcc: Craig Lessor/RIC/Divx)
Subject: Re: extents of tables
Try this bit of SQL:
select a.tabname,
trunc(b.nptotal*4096/1048576,2) as size_MB,
hex(a.partnum) as partnum,
b.nextns as extents,
trunc(b.npused / b.nptotal * 100,0) as perc_used
from systables a, sysmaster:sysptnhdr b
where a.partnum = b.partnum and a.tabid > 99
order by 4 desc
HTH
Jon.
> In article <909423669snz@kontron.demon.co.uk>,
> andy@kontron.demon.co.uk wrote:
> > The 'sysmaster' database has a 'sysextents' pseudo-table that has
> > this information.
> >
> > > From an Informix newbie:
> > >
> > > Can someone tell me how to get a report of the number of extents
> > > per table (not just system tables but data as well)? I know about
> > > onstat -t but this output seems kinda cryptic...> > >
> > > I am running 7.24.UC5-1
> > >
> > > TIA
>
> Thanks Andy....
>
> But what information in this table tells me that I may be in need
> of a reorg? Is it the size field... for example if a table says it
> has a size of 10 does that mean 10 extents?