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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.