This content has been marked as final. Show 1 reply
Please mind there is way too few information to truly know what happened. It requires at least traces of both operations to understand what truly happened.
One thing which could have happened is the following:
- if the BO reports use smartscans/offloading, they do full scans on the segments in the query via direct path.
- data loading requires access to the segments it's about to load or change. This can not be done when these segments are scanned via direct path.
Regular (non-direct path) access does not require the same protection from the database, so loads can co-exists with them much better.
If you can get more information about where the load did wait for, we can do a little more analysis.