The Tablespaces Layer

Above the Memory Structures layer, eG Enterprise’s database server model includes a Tablespaces layer that monitors the health of the individual tablespaces of a database server instance. A tablespace is a logical database structure that is designed to store other logical database structures. The objects that may be stored in a tablespace include tables, indexes, rollback segments, etc.

If a tablespace runs out of space then all the statements that try to acquire new space in that tablespace will fail. If there are too much read or write operations to a specific tablespace this could result in serious performance problems. Hence it is critical to monitor individual tablespaces of a database server instance.

To monitor the health of the different tablespaces of a database server instance, the eG Enterprise suite includes an Oracle Table Spaces test.

Figure 1 : Tests mapping to the Tablespaces layer