Conventional Path Export Versus Direct Path 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來讀取表中的資料,
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-968376/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Conventional Path Export和Direct Path ExportExport
- 解決direct path read 與 direct path write問題
- ORACLE等待事件:direct path writeOracle事件
- direct-path [insert] parallelParallel
- Oracle Direct-Path InsertOracle
- @EXPORT and @EXPORT_OKExport
- direct path read/write等待的分析
- direct path read/read temp等待事件事件
- Oracle中的direct path read事件(轉)Oracle事件
- Append與Direct-Path Insert(一)APP
- Append與Direct-Path Insert(二)APP
- export 和 export default 區別Export
- exportExport
- JavaScript中的export、export default、exports和module.exports(export、export default、exports使用詳細)JavaScriptExport
- export和export default的區別Export
- export ORACLE_SID=founder exportExportOracle
- 【DB】Direct Path EXP Corrupts The Dump If An Empty Table Partition Exists
- 一次direct path read 故障處理
- import、require 、export、export default、exports、module exportsImportUIExport
- FORM ExportORMExport
- export/importExportImport
- Oracle direct path read相關隱含引數Oracle
- 【TUNE_ORACLE】等待事件之IO等待“direct path write”Oracle事件
- Oracle常見等待事件之direct path read/writeOracle事件
- 使用Direct-Path INSERT插入資料到表中
- ES6:export 與 export default 區別Export
- JavaScript ES6中,export與export defaultJavaScriptExport
- 6.exports、module.exports、export、export defalutExport
- module.exports 、 exports 和 export 、 export default 、 importExportImport
- ES6 export && export default 差異總結Export
- ES6 export 和 export default的區別Export
- 【TUNE_ORACLE】等待事件之IO等待“direct path read”Oracle事件
- 【TUNE_ORACLE】等待事件之IO等待“direct path write temp”Oracle事件
- Oracle 11g 中 Direct path reads 特性 說明Oracle
- Oracle 11g direct path read 等待事件的理解Oracle事件
- direct path read wait event 的處理辦法AI
- 【效能調整】等待事件(六) direct path read&write事件
- export default用法Export