Enables Essbase to dynamically determine the retrieval buffer size, between 100 KB and 10 MB, for retrievals from databases without Dynamic Calc, attribute, or Dynamic Time Series members.
This setting does not apply to aggregate storage databases.
VLBREPORT TRUE | FALSE
TRUE—Essbase dynamically determines the size of the retrieval buffer for outlines that qualify.
FALSE—Essbase does not dyamically determine the size of the retrieval buffer. The default setting is FALSE.
Retrieved data is temporarily stored in the retrieval buffer. The size of the buffer can significantly affect retrieval performance. If you have a database which has a very large block size and you retrieve a large percentage of cells from each block across several blocks, consider setting the VLBREPORT option to TRUE. When this is done, Essbase dynamically determines the optimum buffer size between 100 KB and 10 MB, overriding the current retrieval buffer size setting.
Turning on VLBREPORT optimization can improve performance for concurrent and serial queries. Since queries can be completed faster, this optimization also enables more users to perform their queries at the same time.
The VLBREPORT configuration setting applies only to databases that contain no Dynamic Calc, attribute, or Dynamic Time Series members.
The retrieval buffer size is a database property which you can change using the MaxL alter database statement, the ESSCMD SETDBSTATEITEM , or Administration Services Console.
For more information about setting the retrieval buffer size, see the Oracle Essbase Database Administrator's Guide.
VLBREPORT TRUE
alter database (MaxL statement)
SETDBSTATEITEM (ESSCMD)