Number of studies per partition

(DME_PARTITION_DEVQC and DME_PARTITION_PROD) The access level is User.

When users define a study in Oracle DMW they must specify whether they expect the amount of data collected in the study to be small, medium, or large relative to other studies.

These lookups set the maximum number of small, medium, and large studies' data in certain cross-study internal tables that can be stored in a single database partition. Development and QC data are stored in the same partition, while Production data is stored in a separate partition.

The default values are: 1 large study, 5 medium studies, and 20 small studies for both lifecycle partitions.

You can change the default values in the Meaning column. Each value must be different from the others in the same lookup.

See Database partitioning for more information.