sqlldr increase the oracle process memory usage, why?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sqlldr increase the oracle process memory usage, why?

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    sqlldr increase the oracle process memory usage, why?

    Hi,

    I am using oracle 8.1.7 on windows 2000 and I found
    that when I using sqlldr to load a 4M datafile to oracle
    the memory usage shown in the task manager increase, is this normal?

    After I loaded 70 such datafile, I found that the memory usage
    increase from 310M -> 470M. Why?

    I am using "APPEND" inside the sqlldr control file.

    I've tried to use "REPLACE" instead of "APPEND" in the control
    file. Then I found the memory usage increase rate had drop down
    a little bit but still increasing. Is there a way to stop it?

    Thanks for any reply,

    Wayne

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the program needs memory?

    What is the problem here?

Posting Permissions

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


Click Here to Expand Forum to Full Width