Question Alternate Hits in promon still zero

[HeinrichVeerkamp]

Hello,

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.

Regards

Heinrich

 

[Rob Fitzpatrick]

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.

 

[HeinrichVeerkamp]

Thank you for your quick response! Now I know that I have to restart my database.

Regards

Heinrich Veerkamp

 

[HeinrichVeerkamp]

I restarted my database and the Alternate hits are shown.
Thank you very much!