Show TOC

Data Volume Filling LevelLocate this document in the navigation structure


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


The fill level of the data volumes is high. If the fill level is 100%, the database 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