Unix Technical Forum

sqlldr increase the oracle process memory usage, why?

This is a discussion on sqlldr increase the oracle process memory usage, why? within the Oracle Database forums, part of the Database Server Software category; --> Hi, I am using oracle 8.1.7 on windows 2000 and I found that when I using sqlldr to load ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-24-2008, 05:53 PM
Cantonese Boy
 
Posts: n/a
Default 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:36 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com