media/image3.png

You can use the PROSTRCT STATISTICS utility to monitor extents. The utility displays database block usage statistics about extents for each storage area, including:

  • Number of data blocks used
  • Number of total blocks used
The command to monitor extents using PROSTRCT STATISTICS is:
prostrct statistics db-name [> output-file.txt]

Using the statistics provided, you can then calculate the percentage of space used in each storage area using this formula:

Percentage used of a storage area = number of data blocks * 100 / number of total blocks

If the percentage of space used in a storage area is more than 80%, then you should add more extents to the area.

Here is an example of the PROSTRCT STATISTICS report on the Order area of the sports database. Notice the bold text highlighting the number of data blocks and the number of total blocks.
Database: sports
...
 Statistics for Area: Order
 Files in Area: Order
    C:\OpenEdge\WRK\dba\db\sports_11.d1 2097152
    C:\OpenEdge\WRK\dba\db\sports_11.d2 1376256
 Database Block Usage for Area: Order
 Active blocks: 839
 Data blocks: 838
 Free blocks: 1
 Empty blocks: 9
 Total blocks: 848
 Extent blocks: 2
 Records/Block: 32
 Cluster size: 8
...

You can then calculate the percentage of space used in the Order area with this formula:

838 * 100 / 848 = 99%

Because the percentage of space used in the Order area is more than 80%, you need to add more extents to the area.