I'm getting a java.lang.OutOfMemoryError exception (2) | ORA600
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.
Europe
Belgium :
Kurt Van Meerbeeck
ORA600 bvba
E-mail
dude@ora600.be
Cell : +32 495 580714
Denmark :
Henrik Bjerknæs Rasmussen
Service & Support Manager
Miracle AS
E-mail :
hra@miracleas.dk
Cell: +45 53 747 110
North America
USA :
Tim Gorman
Evdbt Inc
E-mail
tim@evdbt.com
Cell : +1 303 885 4526
Canada :
Pythian
E-mail
dude@pythian.com
Contact
Latin America
Brazil :
HBtec
E-mail
dude@hbtec.com.br
Cell : +55 47 88497639
Contact
Africa
South Africa :
Kugendran Naidoo
NRG Consulting
E-mail
k@nrgc.co.za
Cell : +27 82 7799275
East Asia Pacific
Australia
Andre Araujo
Pythian Australia
E-mail
dude@pythian.com
Cell : +61 2 9191 7427 ext. 1270