If DUDE still runs out of memory after setting the heapsize to 2Gb (maxium), then most probably you are dumping large LOB columns. We define a large LOB as a LOB segment
larger then 1Gb.
If this is the case, you should switch on the parameter HUGE_LOB_SUPPORT.
Setting HUGE_LOB_SUPPORT=”true” in dude.cfg will turn on an on-disk-hashing algorithm for unloading lobs (as opposed to in-memory hashing).
The HUGE_LOB_SUPPORT was introduced after a case where DNA strands stored in LOBs had to be unloaded. The table contained - among others - 2 CLOBs columns, each being over 1Gb large.
Kurt Van Meerbeeck
Cell : +32 495 580714
Service & Support Manager
Cell: +45 53 74 71 27
Cell : +1 303 885 4526
South Africa :
Cell : +27 82 7799275
East Asia Pacific
Cell : +61 2 9191 7427 ext. 1270