Hello

I'm trying to understand why my server don't go faster
I have checked cpu (via sar), disk i/o (via iostat) and memory (vmstat). the more cpu that it is used is around 25% and the %busy of disks around 20%.

Our configuration is sun V880 with 4 cpu, 8go Ram and EMC bay disk with 4 controllers.

Oracle 9.2.0.5 is installed.

here's options used for sql*loader :
DIRECT=TRUE DATE_CACHE=10000 COLUMNARRAYROWS=40000 READSIZE=20000000 STREAMSIZE=1024000

UNRECOVERABLE LOAD DATA
TRUNCATE INTO TABLE

I have seen "SQL*Net message from client" and "SQL*Net more data from client" in v$session_wait, but don't know why : i am not using a sql*net connection (sqlldr user/password ), i'am on the server.

Any help apprecied