关于sqlldr bindsize

最新推荐文章于 2024-07-02 20:01:30 发布

转载最新推荐文章于 2024-07-02 20:01:30 发布 · 518 阅读

文章标签：

#数据库

本文介绍了如何使用SQL*Loader通过绑定数组的方式批量向Oracle数据库插入数据。此方法利用SQL数组接口选项一次读取多行数据并存储在绑定数组中，当发送INSERT命令时一次性插入整个数组，从而提高数据加载效率。

Bind Arrays and Conventional Path Loads

SQL*Loader uses the SQL array-interface option to transfer data to the database. Multiple rows are read at one time and stored in the bind array. When SQL*Loader sends the Oracle database an INSERT command, the entire array is inserted at one time. After the rows in the bind array are inserted, a COMMIT statement is issued.

The determination of bind array size pertains to SQL*Loader's conventional path option. It does not apply to the direct path load method because a direct path load uses the direct path API, rather than Oracle's SQL interface.

参考：http://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_control_file.htm#i1005907

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28598517/viewspace-757738/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28598517/viewspace-757738/