We are running an application on Oracle 8.1.7. I have compliants from the application users about the application being slow sometimes.When I monitor the DB - the DB instance everything looks OK. I am unable to find out the exactly cause of the slowness.
I come across some inactive sessions. When I say Inactive session - these are the session that show up in v$session view. This application is running a process in 32 parallel and out of those few sessions are getting INACTIVE and the process getting slow.
The application is simple CLIENT - SERVER based. No Application server (connection pool) is there in the middle.
What might be causing the inactive sessions?