Question Alternate Hits in promon still zero


I added online with proutil dbname -C increaseto -B2 10000 an alternate buffer to my database.

Then I assigned a table and the corresponding indexes to the alternate buffer.

But although I fetched records afterwards from this table, the promon shows as Alternate Hits the value 0.

The version is 11.7 enterprise on Windows.



Rob Fitzpatrick Sponsor
I'm not surprised that your alternate hits are currently zero, since you enabled the feature online. If blocks of the assigned objects were already in the primary buffer pool at the time of the assignments, any subsequent accesses would count as primary hits, since those blocks are on the LRU chain (primary), rather than the LRU2 chain (alternate).

You would see a different result if -B2 had been set at the time of the database start.