Number of blockmap locks.
Number of blockmap locks that waited.
Number of blockmaps instantiated since database creation.
Number of blockmaps instantiated in the monitor interval.
Current blockmap unique ID.
Number of blockmaps allocated in the monitor interval.
Ideal Value.
Number of entries removed from buffer hash.
Number of buffer hash table entries inserted into non-empty hash buckets .
Number of entries in the blockmap hash table.
Number of buffer manager hash table probes.
Number of buffer manager hash table probes that were successful.
Number of buffer hash find calls that hit on 1st try.
Number of buffer hash find calls that hit on 2nd try.
Number of blockmap pages that were inserted into the buffer hash table .
Length of longest chain in buffer hash table.
Number of rehashes due to buffer hash table growing.
Number of times the buffer hash table was locked.
Number of waits on buffer hash table lock.
Count of buffers available to be pinned.
Count of buffers available for prefetch.
Ideal Value.
Count of locks taken on the buffer allocator.
Count of buffer allocator locks that waited.
Count of indexes/structures using prefetch buffers.
Count of indexes/structures using pinned buffers.
Number of calls to post estimated future users.
Count of pinned buffer requested in advance.
Number of calls to unpost estimated future users.
Count of pinned buffers not requested in advance.
Ideal Value.
Ideal Value.
Total buffers managed by buffer allocator.
Length of longest buffer hash chain.
Number on buffer hash table buckets.
Ideal Value.
Number of operations that had to reacquire the table lock.
Number of buffer hash table buckets containing 2 or more entries.
Find requests that waited while a page was being read from disk or written to disk.
Buffers that were cloned to create new versions since previous versions were locked by queries.
Number of buffer cache threads currently inactive.
Description.
Lock used to access IQ catalog.
Number of buffer allocator clients that have pinned buffers.
Number of user mode CPU seconds.
Number of system mode CPU seconds.
Total of system and user seconds.
Number of New Pages Created.
IQ Message File lock.
IQ Message File lock.
Number of pages destroyed.
Number of page modifications requests.
Percentage of pages that have been modified.
Number of CPU seconds used during the run interval.
Secondary cache lookup found the correct buffer.
Number of blocks allocated in store (main or temp).
Number of Finds that were already in the cache.
Flag to indicate when the store is fully allocated (full).
Number of times the freelist was locked.
Number of lock waits on free list.
Number of buffers written to disk by flush.
Number of times the flush operator was called.
Number of clean buffers requested from buffer manager.
Number of request failed (error due to all buffers locked).
Number of buffers that were found clean.
Pages that were grabbed dirty and synchronously written to disk to free a buffer.
Percentage of Finds that were already in the cache.
Number of locks on temporary compression buffer pool.
Locks on temporary compression buffer pool that waited.
Number of buffers in cache marked as being used.
Number of times that the buffer manager LRU was locked.
Number of times that a thread waited to acquire the buffer manager LRU lock .
Number of spin cycles that the buffer manager LRU lock went through .
Number of times that a thread timed out waiting to acquire the buffer manager LRU lock.
Amount of memory currently allocated from Heap.
Maximum amount of memory allocated since server started.
Maximum amount of memory allocated in monitor interval.
Number of requests to allocate memory.
Number of requests to allocate memory since server started.
Number of times the heap was lock.
Number of lock waits on heap.
Number of buffers that after use were put back to MRU.
Number of buffers that after use were put straight into the wash area .
Current count of active commands.
Number of clients currently registered with the buffer allocator.
Total number of teams during monitor interval.
Actual threads allocated by server.
Statistics for prefetch manager lock.
Number of prefetch requests that were dropped.
Number of Prefetch requests started.
Number of PF reads completed.
Number of prefetch requests submitted.
Number of threads reserved for prefetch.
Number of valid prefetch requests.
Number of buffers in cache.
A page requested for prefetch was already in memory.
Find of page requested for prefetch that resulted in a read.
Number of times a client registered with the prefetch manager allocator for prefetch.
Percent of buffers that are pinned in memory (locked).
Maximum number of clients that can register with the buffer allocator for pinned buffers.
Number of times a client registered with the buffer allocator for pinned buffers.
Number of database blocks read.
Size of database blocks read in KB.
Pages Requested for asynchronous prefetch.
Maximum number of clients that can register with the buffer allocator for prefetch.
Number of database blocks written.
Description.
Description.
Number of buffers that in the LRU when a Find occurred.
Number of buffers that were in the wash area when a Find occurred .
Number of buffers that were in scan mode when a find occurred.
Stats repository lock.
Number of stats in status repository.
Pages that were re-read from disk multiple times.
Number of teams that had only one thread.
Resource gate lock.
Database context lock.
Total cost of completed commands.
Maximum number of concurrent commands.
Number of available concurrent commands.
Number of commands that waited at resource gate in monitor interval .
Number of commands currently blocked at resource gate.
Current number of connections.
Total number of thread teams allocated in monotor interval.
Maximum number of thread teams.
Number times thread manager was locked.
Number of thread manager locks that waited.
Number of thread teams currently in use..
Number of threads available for assignment.
Number of CPUs IQ is using.
Actual threads allocated by server.
Description.
Total number of threads requested for server.
Number of times sweeper threads waited for work.
Number of transactions blocked in begin transaction.
Number of transactions with pending commit.
Number of transactions waiting in begin transaction.
Oldest version in use.
Transaction manager post commit lock statistics.
Next Transaction ID.
Transaction manager share main version ID.
Lock used for version ID assignment.
Lock used during transactional commands.
Unowned Re-read. Number of pages re-read on a query server because they were potentially stale.
Average number of threads per command.
Maximum number of buffers can be in the wash area.
Number of buffers flushed from wash area.
Current value of Buffer_Cache_Wash_Intensity option.
Number of sweepers with buffers to write.
Number of clean buffers in the wash area.
Number of dirty buffers in the wash area.
Number of dirty buffers in wash area before sweepers are woken.
Number of threads in the sweeper team.
Pages written to disk.
