Getting Inactive sessions in oracle
Hi all,
I am facing a strange problem. On application level we use 'apps' user to login in oracle. It was working fine earlier. But now a days when we login thru it the performance becomes slow,when I checked the sessions, it shows me 250 inactive sessions.The max limit of sessions is 400.
Then I have to manually kill the inactive sessions and application starts working fine . Any idea about this problem?
Oracle version is 10g version 2
Iplanet version 4.1
Platform Sun solaris 5.8
Thanx and regards

