Sorry its commit=y during import...This should resolve your problem of using all memory.

Regards

Jones

________________________________

From: Doug Harris [mailto:oracledba-ezmlmshield-x49067549.[Email address protected]
Sent: Sat 5/31/2008 12:39 AM
To: LazyDBA Discussion
Subject: imp using all available memory



I just realized that when I do an imp on my system it uses all the
available memory. The export dump file is about 42GB's and the available
memory is 18GB's and goes down to about 50MB's during the import. About
5 minutes after the import finishes it gives the memory back. Any ideas
why it uses all my memory?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html







Oracle LazyDBA home page