Re: Tuning high sys cpu usage.

I think reduce the number of parallel jobs is one way to do. You can merge small data files into a large data file and merge the associated control files into one control file, than using single sql loader to load into different table. This will reduce number of processor load. Pls, look the DBA utility doc for how to do multi table load.

Good luck

Zosen

In article <37F8EBE7.77DFC9DA_at_c2i.net>,   Kjell Tore Nannestad <knannest_at_c2i.net> wrote:
> We are using sqlldr to load data from ascii files.
> Many of the files are small (between 2 and 100 records), and can not
be
> concatenated into larger files.
> We are going to load some 20000 files each night (6 hours).
> To be able to do this we need many parallel jobs, but when starting
more
> than 15 - 30 parallel jobs the
> sys CPU load increases to 80 % and the user CPU load is 15 % (sar
> reports).
> The sar -d shows that the disk writes are reduced from some MB to
> 100kB.
>
> It looks as if much of the time is used to internal Oracle routines.
> A truncate of a table with less than 2000 rows takes up to 90 seconds.
> Sar .-d reports no problems with disk I/O.
>
> Is there anybody that has experienced something similar and have some
> ideas how
> to solve this bottleneck.
>
> Current config:
> SGI Origin 2000 w/6 CPU's and 3 GB memory, 1.5 TB disk (raid 1 or 5).
>
> regards
> Kjell Tore Nannestad
> Consultant mgr.
> ProAct Systems AS
> Norway
>
>

--
Zosen Wang (wangz_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 16:56:43 CDT