Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why use a Unix Pipe to uncompress a file?
> 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
![]() |
![]() |