Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Unanswered: Poor Performance Sql*Loader

    Hi

    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 ).

    Any help apprecied

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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 ...

    Gregg

  3. #3
    Join Date
    May 2003
    Location
    France
    Posts
    112
    I'm running on the server, the table has not any indexes and my oracle version is 9.2.0.5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •