Memory Monitoring

Previous  Top  Next

The Memory Monitor will display 7 areas with information about memory pools.

 

Note:

This functionality only works with InterBase, version 7 or higher.

 

The Memory Monitor screen

 

The following memory pools are available:

REQ

Compiled User Statements

Normal user queries and DML statement which have been compiled into executable requests.

TRA

Transaction Manager

Transaction pools allocate data structures having to do with a transaction such as savepoints and transaction bitmaps for concurrency control.

CCH

Cache Manager

Memory pool from which cache manager data structures are allocated. The major memory allocation is for the page buffers.

DYN

Compiled DDL

Internal request pools specifically having to do with data definition (DDL) operations.

IRQ

Internal Compiled Metadata Statements

Registry of persistent internal requests. InterBase executes internal requests against system tables to maintain and load a database's metadata.

PRM

Metadata Structures

Permanent pool from which internal metadata structures are allocated.

TRG

Compiled Triggers

Trigger pool from which a trigger request is allocated.