exp and memory management.

[marco17]

hi ,

I've some memory problems during exports.
In production my swap and memory used is correct (according with the capabilities of my server), but during exports my swap become nearly full. I can't really increased is size for the moment.
Can i do something to limit the memory used by exp ?

marco.
(sorry for my horrible english)

 

[oradba101]

Hi, Marco17

Perhaps compress=Y in the script?

Regards,



William Chadbourne
Oracle DBA

 

[SantaMufasa]

Actually, "compress=Y" causes the entire contents of each table to be consolidated into a single (possibly gigantic) extent. I don't believe that "compress=Y" has any effect upon memory consumption.

Marco, can you please post the full "exp" command that you are using, which causes the memory-consumption problem?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[marco17]

thanks for your answers :

Here is ther command used for exp :

ficpipe="/prod/export/PipeOracle$$"
jour=`date +%w`
FICLOG=/batch/oracle/exp$SID.$jour.log
FICEXP=/prod/export/exp$SID.$jour.Z
compress -c <$ficpipe> $FICEXP & exp USERID=system/$motdepas FILE=$ficpipe FULL=Y \ GRANTS=Y COMPRESS=Y CONSISTENT=Y LOG=$FICLOG BUFFER=20971520 1>/dev/null

The instance that used to mutch memory supports lots of LOB.

Thansk,
Marco.