insa wrote:You probably did not set your application up correctly. Perhaps there are parameters as to whether you reuse or share connections, and perhaps there are parameters to adjust the result set size. Or maybe it is just a bad application.
i cheked oracle.exe process using lot of memory.
Also,i checked from v$session, when i am starting my application lot of java.exe program connecting to the oracle user.