Extents

Hi folks. For as long as I can remember I've looked at the nextns column in sysptnhdr to get the number of extents in a table. But sysextents shows many more extents than this for the same table. Can anyone settle the argument I'm now having please?! Which is right? My assumption is that sysextents shows all the extents even if they are contiguous and thus count as one. Is this right? Cheers, Jon.

the size from sysextents times your page size tells you the number of pages allocated for the table. the number of rows returned for the one table in sysextents is the number of extents. oncheck -pt dbname:tablename will show you the actuall number of extents jorge :) Jon Myatt wrote: > Hi folks. > > For as long as I can remember I've looked at the nextns column in sysptnhdr > to get the number of extents in a table. But sysextents shows many more > extents than this for the same table. > > Can anyone settle the argument I'm now having please?! Which is right? > > My assumption is that sysextents shows all the extents even if they > are contiguous and thus count as one. Is this right? > > Cheers, > > Jon. -- Jorge Torralba Intel Corporation Technology and Manufacturing Grp HF2-71 Sys. MFG, Information Technology 5200 NE Elam Young Pkwy (503)696-4587 Hilssboro, OR 97124 jorge.torralba@intel.com ============================================================= Any views or opinions expressed by me do not reflect those of Intel Corp **** **** **** * * * * * * **** * * * * *** *** * * **** **** **** * * * * * * * * * * *** *** * * * * * ** * * * * * * * * *** * * * *** * * * * * * * * * * * * * * * * * * * * * * * *** * * * * * * * * * * * * * * * * * * * * * * * * *** *** * * * * * * * * * * * * * **** **** **** ******* ******** **** * * * ****** * * ******