The VALSPERPAGE program calculates the maximum number of values for a variable of a given width that will fit on one page. Pages are units of storage in the workspace.
INTEGER
VALSPERPAGE(n)
An INTEGER
expression specifying the width of a variable in bytes. This value should be between 1
and 4000
. When you specify a value greater than 4000
or less than 1
, the result is NA
.
Oracle OLAP lets you create very large, multidimensional variables. Theoretically, a variable can contain up to 2**63
cells, although this maximum is subject to memory constraints and other factors specific to your system.
Example 8-157 Calculating the Number of Cells in a Page
The following statement calculates the maximum number of cells available in a single page for a variable with an INTEGER
data type. The default width of an INTEGER
value in Oracle OLAP is 4
bytes.
SHOW VALSPERPAGE(4)
The output of this statement is
992