|
|
| Re: conventional and Direct Path [message #70022 is a reply to message #70015] |
Wed, 03 April 2002 15:01   |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
Convertional - the data is export with select (DML) from database, similar to normal select statement. this means the data read from data buffer
Direct - the data is redirect read from block with go through select (DML) statement. this is more faster ..
Hope this is helping
|
|
|
|
| Re: conventional and Direct Path [message #70035 is a reply to message #70015] |
Thu, 04 April 2002 05:34 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
See this article if you have access to MetaLink: Note:155477.1.
Here is a snip:
DIFFERENCE
----------
1. Conventional 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 evaluating buffer. The data, after passing expression
evaluation, is transferred to the Export client, which then writes the
data into the export file.
2. Direct path Export.
-------------------
When using a Direct path Export, the data is read from disk into the
buffer cache and rows are transferred directly to the Export session's
private buffer (Export client). The SQL command-processing layer
(evaluation buffer) is bypassed, because 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
