LucidDbAlterSystem

From Eigenpedia

Jump to: navigation, search

Syntax

ALTER SYSTEM SET unqualified-parameter-name = { literal | MIN | MAX }
ALTER SYSTEM DEALLOCATE OLD

See LucidDbValueExpression for specification of literal.

See LucidDbSystemParameters for available parameters.

The second command frees all pages that are no longer in use. A page is no longer in use if it has been deallocated, or it is an older version of a page that is longer being referenced by active transactions. Once a page is freed, it can be reallocated.

Example

ALTER SYSTEM SET "cachePagesInit" = 5000;