Multiple data load buffers can exist on an aggregate storage database. To save time, you can load data into multiple data load buffers simultaneously.
Although only one data load commit operation on a database can be active at any time, you can commit multiple data load buffers in the same commit operation, which is faster than committing buffers individually.
Note: | When using Administration Services Console to load data into an aggregate storage database, only a single data load buffer is used. |
To load data into multiple data load buffers simultaneously, use separate MaxL Shell sessions. For example, in one MaxL Shell session, load data into a buffer with an ID of 1:
alter database AsoSamp.Sample initialize load_buffer with buffer_id 1 resource_usage 0.5; import database AsoSamp.Sample data from data_file "dataload1.txt" to load_buffer with buffer_id 1 on error abort;
Simultaneously, in another MaxL Shell session, load data into a buffer with an ID of 2:
alter database AsoSamp.Sample initialize load_buffer with buffer_id 2 resource_usage 0.5; import database AsoSamp.Sample data from data_file "dataload2.txt" to load_buffer with buffer_id 2 on error abort;
When the data is fully loaded into the data load buffers, use one MaxL statement to commit the contents of both buffers into the database by using a comma-separated list of buffer IDs:
For example, this statement loads the contents of buffers 1 and 2:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Note: | When loading SQL data into aggregate storage databases, you can use up to eight rules files to load data in parallel. This functionality is different than the process described above. When preforming multiple SQL data loads in parallel, you use one import database MaxL statement with the using multiple rules_file grammar. Essbase initializes multiple temporary aggregate storage data load buffers (one for each rules file) and commits the contents of all buffers into the database in one operation. See the Oracle Essbase SQL Interface Guide. |