Maximum Limit of HDL to load 7 million records & Best Practices, related performance issues in ORC
We are planning to load 7 million Candidate data (Requisitions, Candidates, Candidate Job Application) into ORC application through HDL, hence we would like to know below information.
1. Is there any restriction on the number of records to be loaded through HDL, If yes what is the maximum limit on number of records can be loaded and what is the maximum size of HDL zip file allowed for a one time load
2. After we load 7 million records, will there be any performance issues on the ORC UI
3. Is there any standard document available which describes the Oracle recommended best practices to be followed to load large volume of 7 million data through HDL