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.
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 ).
Were you running the load from the server or from a client ???
If you had a large load and were running from a client, then you would have
"SQL*Net message from client" and "SQL*Net more data from client" waits...
Whats the network speed ??? If you ran this from the server, then there is another problem ... What version of Oracle ? Did the table getting the load have indexes ??? I would remove indexes prior to the load then rebuild them after ...