Procedure documentationDisplaying Information About Caches (Working Memory Areas) Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as the database system administrator or as a DBM operator.

  • The database is in the ONLINE operational state.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose Administration.

  3. Open the Caches tab page.

    Cache Information

    Property

    Description

    Cache Sizes

    Size of the different working memory areas.

    More information: Concepts of the Database System, Working Memory Areas

    Cache Accesses

    The hit rates show whether the caches have been configured sufficiently large. The lower the hit rates, the poorer your system's performance.

    Recommendation Recommendation

    We recommend the following hit rates:

    • Data cache > 99%

    • Converter > 98%

    • Catalog cache > 90%

    End of the recommendation.

    Parameters

    Database parameters relevant to the caches

    More information: Database Administration, Database Parameters

More Information

Database Administration, Monitoring Databases