[nhusers] Memory Issue while creating the multiple session factories for the Schemas in oracle containing around 950 tables.

[seshu Kumar R. S. R.]

Hello Team,
I am facing an issue with the memory while creating the session
factories for all my schemas in oracle.

The issue is bellow.

I have around 13 schemas in the oracle. I want to create the session
factories for all the schema in one go when my application starts. I am
going to store the all the created session factories in one dictionary
object by mentioning the schema name as the key.
But I am facing an issue, where 12 session factories are creating
successfully, but when I am trying to create the 13th one, I am getting out
of memory exception, And also the 12 session factories are consuming
around 1 GB of memory.

Is there any way to reduce the memory usage of the session factories.
And the count of all the tables in the database is around 950.

Please suggest me the solution.

Thanks & Regards,
Seshu Kumar.