Conventional Path Export Versus Direct Path Export

最新推荐文章于 2012-07-25 19:29:25 发布

转载最新推荐文章于 2012-07-25 19:29:25 发布 · 81 阅读

本文介绍了Oracle Export工具的两种导出方式：传统路径导出和直接路径导出。传统路径导出利用SQL SELECT语句从表中提取数据，并通过评估缓冲区进行数据转换。而直接路径导出则更快速，它绕过了评估缓冲区，直接将数据从磁盘读取到缓存，并传输到Export客户端，避免了不必要的数据转换。

Export provides two methods for exporting table data:
■ Conventional path Export
■ Direct path Export
Conventional path Export uses the SQL SELECT statement to extract data from
tables. Data is read from disk into a buffer cache, and rows are transferred to the
evaluatingbuffer.Thedata,afterpassingexpressionevaluation,istransferredtothe
Export client, which then writes the data into the export file.
Direct path Export is much faster than conventional path Export because data is
read from disk into the buffer cache and rows are transferreddirectly to the Export
client. The evaluating buffer is bypassed. The data is already in the format that
Export expects, thus avoiding unnecessary data conversion. The data is transferred
to the Export client, which then writes the data into the export file.

不通过内存，直接将数据写出到磁盘 ,直接导出数据(通过cached commit scn 加载数据)，数据不需要经过内存整合和检查
这样减少了sql语句处理的过程.否则exp将使用select来读取表中的数据，

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-968376/