Re: exp performance question ( direct=y)

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 22 Jun 2001 10:52:13 -0700
Message-ID: <F001.00334129.20010622110048@fatcity.com>

I thought that DIRECT=Y was for imports only. It makes since because in the import you are placing the data directly into the blocks with out a redo log. I have no idea why there was a difference in the times unless it was the extra overhead for a command that was not used. ROR mª¿ªm

>>> zlmei_at_hotmail.com 06/22/01 12:55PM >>> Oracle : 8.0.5
Platform : Sun

Currently we have cron job every night (starting from 11pm) to do export. I changed the setting "direct" to "y" two days ago while leaving all other parameters unchanged, hoping to gain some performance. I am a bit surprused to find that it did not. It actually took longer to create dump file with less data to export. The whole exp process takes about 2 hours to finish. Yes, there could be lots of other unix processes running during that time. But I would still expect to see some improvement because we are doing this way for quite a while. So my questions are:

From your "real" export experience, how much performance boost did you see when you set "direct=y"?
If "direct=y" improves the performance, why would anyone want to use "direct=n"?

Thanks.

Guang

here is my orcle dump file's time stamp: (dmp.1 and dmp.2 are from direct=y, dmp.3, dmp.4 and dmp.5 are from direct=n).

-rw-rw-r-- 1 mt prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz
-rw-rw-r-- 1 mt prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz
-rw-rw-r-- 1 mt prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz
-rw-rw-r-- 1 mt prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz
-rw-rw-r-- 1 mt prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz

--here is the parameter file:

BUFFER = 64000
COMPRESS = Y
CONSISTENT = N
CONSTRAINTS = Y
DIRECT = Y
FILE = /oracle/exports/oracle.dmp.pipe
#FULL = Y
GRANTS = Y
INDEXES = Y
LOG = /oracle/exports/export.log
ROWS = Y
USERID = xxx/yyy
OWNER = (aaa,bbb)

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guang Mei
INET: zlmei_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ron Rogers
INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message