Hello,
i have the following problem with HS (10g: hsodbc.exe and 11g: DG4MSQL + DG4ODBC):
The memory allocated by the HS agent is increasing continuously.
Only closing the database link will deallocate the memory again.
alter session close database link DBL_MSSQL;
So what i do is close the database link after a certain number of records are processed to clear / deallocate the memory again.
Is there a possibility to prevent this behaviour of the HS agent?
Has anybody else made the same experience?
Many thanks in advance for any help.
Regards Hartmut