Home » RDBMS Server » Server Utilities » conventional and Direct Path
conventional and Direct Path [message #70015] Wed, 03 April 2002 02:28 Go to next message
kimm
Messages: 3
Registered: April 2002
Junior Member
What is the different between conventional and Direct
Path when exporting a table.

Pls reply
Re: conventional and Direct Path [message #70022 is a reply to message #70015] Wed, 03 April 2002 15:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: conventional and Direct Path [message #70098 is a reply to message #70035] Fri, 12 April 2002 07:39 Go to previous message
kimm
Messages: 3
Registered: April 2002
Junior Member
Thanks a lot log the point
Previous Topic: Re: Urgent!!! SQL * LOADER ERROR-524
Next Topic: Re: OCP Exam Papers
Goto Forum:
  


Current Time: Sat Dec 03 23:20:44 CST 2022