-
SQl*Loader poor perfomance
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|