Using the Catalog Buffer Monitor
The database catalog buffer caches metadata about tables that have been recently accessed using Open SQL. A single catalog buffer instance exists for each used database schema. Although it is possible to register several DataSource objects for a particular database schema, the same catalog buffer is used for the schema. You use the Catalog Buffer Monitor to obtain statistics about the status and the use of the catalog buffer.
You are in the
Problem Management 
Database Open SQL Monitors Catalog Buffer Monitor 
function of SAP NetWeaver Administrator.
On the Accessed Catalog Buffers screen, you can choose a catalog buffer instance that you want to monitor. A catalog buffer is displayed along with the following details:
|
Parameter Name |
Description |
|---|---|
|
Cluster Node |
The ID of the cluster node. |
|
Buffer ID |
A unique identifier for a catalog buffer instance within a cluster node. It is created by the concatenation of the database host, the database name, and the database schema. |
|
References |
Current number of catalog readers associated to the catalog buffer instance |
|
Max |
Maximum number of entries in the buffer |
|
Current |
Current number of entries in the buffer |
|
Free |
Remaining free positions |
|
Displacements |
Number of displaced entries in the buffer |
When you select a catalog buffer from the list, the Buffered Catalog Tables screen area displays a list with tables for that buffer ID.
To view the cataloged table columns, select a table in the list. The Columns of Catalog Table screen area displays data for each column in the selected table.