data manipulation of a large unix file

From: <ryan.gaffuri_at_cox.net>
Date: Thu, 22 Jan 2004 06:59:41 -0800
Message-ID: <F001.005DDD95.20040122065941@fatcity.com>

We are getting a feed of an 800 MB file that will come in nightly. It needs to be loaded to the database. Per requirements, we have to add some data to the file before loading(its not negotiable).

ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not allowed to stream it with a named pipe. any other solutions?

--

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

Author: <ryan.gaffuri_at_cox.net
  INET: ryan.gaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Jan 22 2004 - 08:59:41 CST