RE: exp performance question ( direct=y)

From: <Yosi_at_comhill.com>
Date: Fri, 22 Jun 2001 14:08:17 -0700
Message-ID: <F001.003347A8.20010622141108@fatcity.com>

Don't you wish you
could take back posts? (Jared, Bruce - how's that for a
feature!?)

Rows is SQL*Loader,
not exp/imp. I mean it's exp/imp also, but it means something else in
Loader, and in Loader it differs for direct path.
And I
meant Loader's
bindsize also, not exp/imp's buffer.

I mean... well never mind what I
mean. Basically, ignore that first
para-
graph. Read Chris'
post, ignore mine, I've had it, and I'm outta here. It's been a long week,
and it's time for a weekend.

Have a great one
y'all.

y


<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
-----Original Message-----From: Yosi Sent: Friday, June 22, 2001 5:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: exp performance question ( direct=y)
 I believe so. It
 may have a slightly different meaning. Rows, commit,

these things act a
 little differently. (Is that not specific enough?) And
 direct is an exp
 param, that greatly affects your imp.

 Statistics
 is another
 exp
 parameter that takes affect on import. The
 export puts a
 stats statement in the dump file, which imp finds and executes. I
 imagine direct works the same way.
<SPAN

 class=923053319-22062001>
 A quick test on a
 tiny table shows that conventional exp creates a dump file that's
 slightly bigger. Visually, in a text editor, both files look very much
 alike.
<SPAN

 class=923053319-22062001>
 And the timing
 difference - for the export - was BIG. The conventional exported
 in 12 seconds, the direct was INSTANT, less than a second.
<SPAN

 class=923053319-22062001>
 I've experienced
 the same on large tables, and I probably even have timings saved
 somewhere.
<SPAN

 class=923053319-22062001>
<SPAN

 class=923053319-22062001>HTH,
<SPAN

 class=923053319-22062001>
 Yosi
<FONT

 size=2>
<SPAN

 class=923053319-22062001>
<SPAN

 class=923053319-22062001> -----Original Message-----From: Mohan, Ross
 [mailto:MohanR_at_STARS-SMI.com]Sent: Friday, June 22, 2001 4:01 PMTo: Multiple recipients of list ORACLE-LSubject: RE: exp performance question ( direct=y)
<BLOCKQUOTE dir=ltr

 style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> I dunno. Does the BUFFER
 still matter when DIRECT=Y?

 If so, I either remove it
 entirely, or multiply it by about a factor of five or so.

    my
$0.02

      <FONT face=Tahoma 
      size=2>-----Original Message-----From: JOE TESTA 
      [mailto:JTESTA_at_longaberger.com]Sent: Friday, June 22, 2001 3:43 
      PMTo: Multiple recipients of list ORACLE-LSubject: 
      Re: exp performance question ( direct=y)
      Ron, 
       
      ok i'm now confused, 
       
      exp direct=n|y
      imp no such option
      sql_loader has direct also.
       
      or am i missing something here?
       
      joe
       
      >>> RROGERS_at_galottery.org 06/22/01 03:00PM 
      >>>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.5Platform : SunCurrently 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:1. From your "real" export experience, how much 
      performance boost did you see when you set "direct=y"?2. 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 = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = 
      YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = 
      YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS 
      = YUSERID = xxx/yyyOWNER = 
      (aaa,bbb)_________________________________________________________________Get 
      your FREE download of MSN Explorer at <A 
      href="http://explorer.msn.com">http://explorer.msn.com -- 
      Please see the official ORACLE-L FAQ: <A 
      href="http://www.orafaq.com">http://www.orafaq.com -- Author: 
      Guang Mei  INET: zlmei_at_hotmail.com Fat City Network 
      Services    -- (858) 538-5051  FAX: (858) 
      538-5051San Diego, 
      California        -- Public Internet 
      access / Mailing 
      Lists--------------------------------------------------------------------To 
      REMOVE yourself from this mailing list, send an E-Mail messageto: 
      ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe 
      message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
      mailing list you want to be removed from).  You mayalso send the 
      HELP command for other information (like subscribing).--Please 
      see the official ORACLE-L FAQ: <A 
      href="http://www.orafaq.com">http://www.orafaq.com--Author: 
      Ron Rogers  INET: RROGERS_at_galottery.orgFat City Network 
      Services    -- (858) 538-5051  FAX: (858) 
      538-5051San Diego, 
      California        -- Public Internet 
      access / Mailing 
      Lists--------------------------------------------------------------------To 
      REMOVE yourself from this mailing list, send an E-Mail messageto: 
      ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe 
      message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
      mailing list you want to be removed from).  You mayalso send the 
      HELP command for other information (like

subscribing). Received on Fri Jun 22 2001 - 16:08:17 CDT