First of all.. i have zero access to admin the servers in question.. i m just a user... but trying to get some info here ...
Oracle 10g 10.2.0.1.0
I use the following query to keep track of connections from my program...
SELECT
sid,serial#,Status,State,Wait_Class,seconds_in_wait
FROM v$session where program = 'CL_Server.exe'
So this will give me a list of sessions... 99% of the time they are all Inactive/Waiting/Idle status
Sometimes I may have 70+ of these guys , which is correct.. 70+ people using said program.
Is this a HUGE problem? Does it over tax the server? Should DBA be freaking out about these?
I have already changed my application for the next release to autoclose connections when no datasets are active.
Doesn't seem to slow down noticable enough reestablishing connections when needed. But until this release goes
out, I keep getting bugged about the ammount of sessions from my app, even tho they are mostly always in idle state.