Displaying the Database Activity

Item	Description
Bufferpool size	The total amount of memory available for caching database blocks.
Current used bufferpool size	The amount of memory currently being used to store cached database blocks.
Current number of Index blocks	The number of currently cached blocks from the Index part of the database.
Current number of Data blocks	The number of currently cached blocks from the Data part of the database.
Current number of Temp blocks	The number of currently cached blocks from the Temp part of the database.
Number of buffer flushes	The number of physical writes from the buffer pool to the disk that have occurred during the current CentraSite session. A buffer flush is the process whereby CentraSite copies the entire contents of the buffer pool to disk, then deletes the contents of the buffer pool. This frees up the buffer pool for subsequent logical I/O operations.
Logical reads	The number of database read operations that accessed the buffer pool during the current CentraSite session.
Physical reads	The number of database read operations that caused a physical disk access during the current CentraSite session.
Bufferpool hit rate	The ratio of times that a read operation was satisfied from the buffer pool rather than from the disk during the current CentraSite session, expressed as a percentage.
Current bufferpool hit rate	The buffer pool hit rate, limited to the time period between the previous and current activation of the command showactivity.
Flush limit	The maximum amount of buffer pool space that can be in use before a buffer flush takes place. If this value is exceeded, an automatic buffer flush occurs.
Modified pages in bufferpool	The ratio of modified pages to unmodified pages in the buffer pool, expressed as a percentage.
Dynamic pool size	The size of the dynamic pool. The dynamic pool is a separate cache area, not part of the main buffer pool, and is used as a work area for certain operations such as sort and search operations. The dynamic pool is shared across all users of the system.
Current used dynamic pool size	The amount of the dynamic pool currently in use.
Maximum pool usage	The high-water mark of the dynamic pool usage during the current session.
Current number of space waiters	The number of users or applications that are currently waiting for space allocation in the dynamic pool.
Total number of space waiters	The total number of users or applications that have waited for space allocation in the dynamic pool during the current session.