Oracle® Business Intelligence Server Administration Guide > Query Caching in the Oracle BI Server > Using the Cache Manager >

Displaying Global Cache Information


Select Action > Show Info... to display global cache information. Table 29 describes the information that appears in the Global Cache Information window.

Table 29. Global Cache Information
Column
Description

Amount of space still available for cache storage use

The amount of space, in megabytes, still available for cache storage.

Amount of space used on disks containing cache related files

The total amount of space, in megabytes, used on the disk containing cache-related files (not just space used for the cache-related files).

Maximum allowable number of entries in cache

The maximum number of entries that may be in your cache, from the MAX_CACHE_ENTRIES parameter in the NQSConfig.INI file.

Maximum allowable number of rows per cache entry result set

The maximum number of rows allowed for each cache entry's result set, from the MAX_ROWS_PER_CACHE_ENTRY parameter in the NQSConfig.INI file.

Number of entries currently in cache

The current number of entries in your global cache. These entries may relate to multiple repositories.

Number of queries not satisfied from cache since startup of Oracle BI Server

Cache misses, since the last time the Oracle BI Server was started.

Number of queries satisfied from cache since startup of Oracle BI Server

Cache hits, since the last time the Oracle BI Server was started.

With the Cache Manager as the active window, press F5, or select Action > Refresh to refresh the display. This retrieves the current cache entries for the repository you have open, as well as the current global cache information. If the DSN is clustered, information about all repositories in the cluster will be displayed.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.