Does ALTER DATABASE RESTORE CACHE run in the background?

VolkerBarth — Fri, 11 Nov 2022 04:26:34 GMT

The 17.0.11 SP1 docs state for the ALTER DATABASE RESTORE CACHE statement:

The effect of the statement is the same as that of calling the sp_read_db_pages system procedure for each dbspace with the bitmap stored in the prefetch_column of the SYSDBSPACE system view.

Question: Does this run in the background? The sp_read_db_pages() procedure has an optional "in_background" parameter but AFAIK the docs don't tell whether this parameter is set as default or not, and therefore it's not clear for ALTER DATABASE RESTORE CACHE either.

We think about using that statement within a database start event if cache contents has been stored beforehand (as noted in SYSDBSPACE.saved_cache_pages), say for a regular restart. However, it should NOT disturb the database's availability, so background processing would be strongly favoured.

Re: Does ALTER DATABASE RESTORE CACHE run in the background?

VolkerBarth — Tue, 22 Nov 2022 01:10:56 GMT

Any information from the doc team would be appreciated... 🙂

Question Re: Does ALTER DATABASE RESTORE CACHE run in the background? in Technology Q&A

Does ALTER DATABASE RESTORE CACHE run in the background?

Re: Does ALTER DATABASE RESTORE CACHE run in the background?