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: Why use a Unix Pipe to uncompress a file?

Re: Why use a Unix Pipe to uncompress a file?

From: Steven Lembark <lembark_at_wrkhors.com>
Date: Wed, 14 Aug 2002 18:53:21 -0800
Message-ID: <F001.004B5826.20020814185321@fatcity.com>

> I am trying to work thru the one of the scripts that I inherited and I was
> wondering if someone could shed some light on why the author used a UNIX
> PIPE to uncompress a file.

Few reasons:

(1) Many file systems blow up w/ files > 2GB, they are a

    mess in any case. Dumping the output to a pipe avoids     the issue, so long as the sqished output is < 2GB.

(2) If you dump the output to a flat file then you need

    the dump space + zip output space. Dumping to a named     pipe puts only the squished stuff on media.

(3) Saving Truly Large (tm) files to the disk causes

    much more kernel overhead than spitting the data     into a pipe; savings there is time and overhead     (leaves more cycles and I/O bandwidth avilable for     other proc's running on the box).

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.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).
Received on Wed Aug 14 2002 - 21:53:21 CDT

Original text of this message

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