Out Of Memory in Production DB - Suggestions
I am getting out of memory While running my application in Production database (size 950 GB) . For testing we have extracted data (15 GB) and ran the application we didn't get any out of memory.
Note: The reader query will get same 200 records for both the production copy and also the Extracted copy.
We have increase the Heap memory to 1 GB (-Xmx1024m) and -XX:MaxPermSize=1024m. but still we have same issue.
We have requested for the HeapDump to analysis the Memory Leak.(Waiting for the HeapDump). Once we get HeapDump we can use VisualVM to identify the issue. Currently we don't have access to the Production copy.
We are using Spring batch 2.1, Hibernate3, Sql server 2005.
Can anyone suggest what will be the issue?
Thanks & Regards,