Threads that the database server uses

The database server uses the following threads to insert the data into the database:
Table 1. Threads that insert 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.

Copyright© 2018 HCL Technologies Limited