GC overhead limit exceeded error during data comparison

[Sowmyashree K]

Hi Team,

I am comparing data  between 2 tables where each table has 2 million records and comparison is between oracle and postgresql db . Its failing with GC overhead limit exceeded error. Can any one tell me how to resolve this error.

I set it up max heap size as 3gb like this - dbsolo_64bit.exe -Xmx3072m.

I am not sure whether its setting properly or not. Is there any way in the tool we can check the max heap size allocated?

 

I am using DB Solo 5.3 - 64 bit windows 10 

[DB Solo Admin]

The correct format for the option is this

-J-Xmx4096m

There is a memory indicator bar in the upper right-hand corner of the tool, you can see how high it will go and determine from that what the max heap size is.

Marko