[oracle-l] Re: data manipulation of a large unix file
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'ORACLE-L@xxxxxxxxxxx'" <ORACLE-L@xxxxxxxxxxx>,"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Jan 2004 09:20:20 -0600
Ryan - Can you provide more details? Typically ksh scripts are much, much
more efficient than alternate methods, such as manipulating data within the
database. Depending on which method you are using to measure CPU usage, you
may be seeing 1/4 of one CPU. But even if your script is using a full CPU,
that may not be unreasonable. The real question is how long the CPU is used.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
Sent: Thursday, January 22, 2004 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject: data manipulation of a large unix file
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@xxxxxxx
INET: ryan.gaffuri@xxxxxxx
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@xxxxxxxxxxx (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).
Other related posts:
- » [oracle-l] Re: data manipulation of a large unix file
