What are conventional path loads?
What are conventional path loads?
Rating:
A conventional path load is a method of loading data into tables. This method uses the SQL INSERT statement and a bind array buffer for loading the data. It is the default method employed by every Oracle tool and application. In conventional path loads, the SQL*Loader has to compete with all other Oracle processes for buffer resources. However, this significantly deteriorates the speed of the load process as compared to direct path loads. Conventional path loads search for partially filled data blocks to fill them at each insert operation. This process also deteriorates the speed of conventional path loads. Conventional path loads are generally employed for loading data into clustered tables or where a small number of rows are to be inserted into a large indexed table.
Rating:
Other articles
- What is data dictionary?
- What are the steps involved in performance tuning?
- What is Oracle Intelligent Agent?
- What is the REBUILD option of the ALTER INDEX statement?
- What are stored outlines?