upper limit on extents

Does anybody have a script that can determine the upper limit of extents as described in the Admin Guide ? It's easy for me to do on a table level, but I get stumped when doing it on a fragment level. I would need to find the Physical Address on the fragment that contains the most number of extents, or possibly on each and every fragment in a table. Thanks. Floyd ======================== email: floyd@fwellers.com Home: 703-430-0805 Cell: 703-477-6045 ======================== www.one.org www.myspace.com/onepriority

On Aug 9, 10:17 am, fl...@fwellers.com wrote: > Does anybody have a script that can determine the upper limit of extents as described in the Admin Guide ? > It's easy for me to do on a table level, but I get stumped when doing it on a fragment level. I would need to find the Physical Address on the fragment that contains the most number of extents, or possibly on each and every fragment in a table. > > Thanks. > > Floyd > > ======================== > email: fl...@fwellers.com > Home: 703-430-0805 > Cell: 703-477-6045 > ======================== > > www.one.orgwww.myspace.com/onepriority As all fragments have to use the same page size, they all have the same max number of extents. You only need to find one. Zachi