Show TOC

Displaying 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.

    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

    We recommend the following hit rates:

    • Data cache > 99%

    • Converter > 98%

    • Catalog cache > 90%

    Data Cache Usage

    Information about the usage of different parts of the data cache

    Parameters

    Database parameters relevant to the caches

    More information: Database Administration, Database Parameters

Next Steps

Database Administration, Monitoring Databases