ITPub博客

首页 > 应用开发 > IT综合 > Conventional Path Export Versus Direct Path Export

Conventional Path Export Versus Direct Path Export

原创 IT综合 作者:tsinglee 时间:2007-09-07 16:05:58 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892180