We have a nightly batch process that sqlldr records into a staging table. When we process the file, we break up the file into chunks i.e. 1000 records at a time. so our query looks like 'select * from stg where rownum < 1000 order by account_number'.
On occasion the process will skip rows, i.e. it will process 1-150, skip 50 records, and then continue 200-999. What causes this?
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.