[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Extent Utilization

  • Thread starter Thread starter Paul Koufalis
  • Start date Start date
Status
Not open for further replies.
P

Paul Koufalis

Guest
A bit of math will do it. Dividing the fixed extent sizes by the block size will give you the number of blocks in each physical file. DBAnalys will tell you how many active blocks there are. WIth your example, each 1 GB extent has 262,144 4K blocks. DBAnalys tells you the block high water mark. Divide by 262,144 and you'll know what file new blocks will be formatted in and hence which files are already being used. Paul

Continue reading...
 
Status
Not open for further replies.
Back
Top