Background documentationData Volume Filling Level Locate this document in the navigation structure

 

Data volume filling level <percentage>%, <number_of> pages configured, perm used <perm_used>, temp used <temp_used>

Explanation

The fill level of the data volumes is high. If the fill level is 100%, the database instance stops.

User Response

If the amount of data that needs administering in the database instance has increased, you may need to add a new data volume.

A large proportion of temporary data pages (temp used) indicates large amounts of (buffer) result sets. Find the statement that is causing these large amounts of (buffer) result sets to be created, and check the access strategies for this statement.

For information on creating optimized SQL statements, see the SQL Optimizer documentation.

More Information

Database Administration, Adding Data Volumes