Use this parameter to specify the maximum number of events or audit records that are migrated from the CMS to the data warehouse in each batch.
The data warehouse runs multiple batches until it has migrated all the CMS data that was ingested since the previous run; or until processing the backlog of historic data is suspended because the off-peak processing window ends, or all the historic data has been processed.
Specifies the number of events and audit records that are inserted into the data warehouse in each batch.
@Insert_Batchsize = n
Insert_Batchsize => n
In this example, 100,000 events are migrated to the data warehouse in each batch:
@Insert_Batchsize = 100000 Insert_Batchsize => 100000
Large batch sizes speed up data migration; but because large batch sizes require excessive database locks and use significant amounts of UNDO (Oracle), they also increase the load on the database server. Smaller batch sizes allow for less resource-intensive, but slower migrations.
|
Copyright © 2012 CA.
All rights reserved.
|
|