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.

asked 11 Nov, 04:26

Volker%20Barth's gravatar image

Volker Barth
39.1k353534804
accept rate: 34%

Any information from the doc team would be appreciated... :)

(22 Nov, 01:10) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×216
×89
×26

question asked: 11 Nov, 04:26

question was seen: 104 times

last updated: 22 Nov, 01:10