There are multiple SNP Outboard™ parameters that you can adjust in order to tune the performance when creating and reading SNP Outboard™ star schema aggregates:
-
AGGREGATE_FILLING_BUFFER_PACK: Sets how many records are pre-aggregated from NLS storage upon their retrieval and stored in an internal table as an aggregated package. At least one full NLS package is always aggregated.
After the range for the aggregated package is read, the result is written into the database and new NLS packages are processed. DEFAULT VALUE: 300,000
-
AGGREGATE_FILLING_BUFFER_SIZE: Sets the buffer size for dimension table entries. Records are first inserted into internal tables until reaching the size of this parameter. Once the boundary is reached, records are inserted into the database. Default value: 100,000
-
AGGREGATE_FLLING_MASS_READ: Specifies how many records at once are selected from the aggregate fact table in the database. The higher the value, the more complicated the SELECT that is executed on the database. Default value: 100
-
AGGREGATE_FLLING_MASS_INSERT: Sets the number of records inserted into an aggregate fact table in one processing block.
-
AGGREGATE_FORCE_STAR_SCHEMA: Forces aggregates with less than 16 characteristics to be built in star schema mode in the secondary database.
-
SET_DEFAULT_SM_STORID_FOR_AGG: Identifies the storage from Storage Management in which the aggregate is created. This feature is only supported for transparent Oracle storage.
