Hello Guys,
Today I will be discussing about a very common issue when running the DAC Execution Plans.
Many tasks in DAC EP will be failing at a time with "Error: Java heap space". There will not be any more details in the log too. To fix this issue we need to make some changes to the DAC server startup script on the DAC Unix or Windows server machine.
To resolve the issue:
1. Find out a file called startserver.sh/.bat under DAC server folder.
2. Back up this file.
3. Find an entry starting with java.... On this line, locate the -xms paramter and change it (i.e. to -Xms512m -Xmx1536m). You can increase these values according to the load on your server, though keeping huge values isn't recommended.
4. Save the file and close it.
5. Restart the DAC server and kickoff the load.
Cheers,
Siva
Today I will be discussing about a very common issue when running the DAC Execution Plans.
Many tasks in DAC EP will be failing at a time with "Error: Java heap space". There will not be any more details in the log too. To fix this issue we need to make some changes to the DAC server startup script on the DAC Unix or Windows server machine.
To resolve the issue:
1. Find out a file called startserver.sh/.bat under DAC server folder.
2. Back up this file.
3. Find an entry starting with java.... On this line, locate the -xms paramter and change it (i.e. to -Xms512m -Xmx1536m). You can increase these values according to the load on your server, though keeping huge values isn't recommended.
4. Save the file and close it.
5. Restart the DAC server and kickoff the load.
Cheers,
Siva
No comments:
Post a Comment