media/image2.png

As your database runs and update operations occur, new data is continually added to the database. You should proactively monitor the space usage of extents and take steps to ensure that your database has enough space for new data.

As a general rule, if more than 80% of a storage area is used, then you should add more fixed extents to the area. Recall that the variable extent (the last extent) of a storage area should be used only as a safety net to catch overflow data in large update operations.

Progress® OpenEdge® RDBMS provides two tools to monitor extents, the PROSTRCT STATISTICS utility and OpenEdge Management.

You will learn how to monitor extents using each of these tools next.