Threads that the database server uses
The database server uses the following threads to insert the data
into the database:
Thread | Description |
---|---|
pl_wkr threads | Each worker thread of the onpload utility
is paired with a pl_wkr thread in the database server. These
threads receive the data from onpload. In a utility that shows the database server status, the pl_wkr threads are named pl_wkr_1, pl_wkr_2, pl_wkr_3, and so on. |
cadiload threads | The cadiload threads are the insert threads. The insert threads perform a normal insert into the database, like during an INSERT statement. The SQL optimizer governs the method that is used for inserting the data. |