My SQL*Loader use to take 5 minutes to load 70,000 records, and then overnight it started taking 5 hours (went from 2 to 5 in two days) to load just 20,000. I split the records in batches of 50,000 which took 13 minutes per batch, but then this started to take 3 hours and now the whole day!
However, if I load multiple batches (50,000 records) at the same time (like 4 SQL*Loaders running) I can get back the 13 minutes load time.
Why is this happening and how do I solve this please? I'd really appreciate any help as the shareholders are taking about jobs be lost and it's my job evaluation period now.
Thanks.
However, if I load multiple batches (50,000 records) at the same time (like 4 SQL*Loaders running) I can get back the 13 minutes load time.
Why is this happening and how do I solve this please? I'd really appreciate any help as the shareholders are taking about jobs be lost and it's my job evaluation period now.
Thanks.