Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: direct =y in export statement

Re: direct =y in export statement

From: Veera Prasad <vprasad_at_olf.com>
Date: Tue, 31 Oct 2000 15:27:51 -0500
Message-Id: <10666.120730@fatcity.com>

--------------E034CD1F8456B5CC0AE3A407
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

In Conventional path:
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.

In Direct path:
Direct path Export extracts data much faster than a conventional path export.
Direct path Export achieves this performance gain by reading data directly,
bypassing the SQL command processing layer and saves on data copies whenever possible.

In a direct path Export, data is read from disk into the buffer cache and rows
are transferred directly 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.

Veera
Note: I did cut and paste from documentation.

Swapna_P wrote:

>
>
> what does this indicate?
> what is its significance?

--------------E034CD1F8456B5CC0AE3A407

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<b>In Conventional path:</b>
<br>Conventional path Export uses the SQL SELECT statement to extract data
<br>from tables. Data is read from disk into a buffer cache, and rows are
transferred
<br>to the evaluating buffer. The data, after passing expression evaluation,
is
<br>transferred to the Export client, which then writes the data into the
export file.
<p><b>In Direct path:</b>
<br>Direct path Export extracts data much faster than a conventional path
export.
<br>Direct path Export achieves this performance gain by reading data directly,
<br>bypassing the SQL command processing layer and saves on data copies
<br>whenever possible.
<p>In a direct path Export, data is read from disk into the buffer cache
and rows
<br>are transferred directly to the Export client. The evaluating buffer
is bypassed.
<br>The data is already in the format that Export expects, thus avoiding
unnecessary
<br>data conversion. The data is transferred to the Export client, which
then writes
<br>the data into the export file.
<p>Veera
<br>Note: I did cut and paste from documentation.
<p>Swapna_P wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Arial"><font color="#000080">what does this indicate?</font></font>
<br><font face="Arial"><font color="#000080">what is its significance?</font></font></blockquote>
Received on Tue Oct 31 2000 - 14:27:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US