Problem Connections (V$SESSION)

[sahernandez]

Hi, I have a big problem,

I have One VB appl program running over in XP and Win2K.

select cOUNt(*) , osuser , MACHINE , PROGRAM , TERMINAL
from V$SESSION
where schemaname = 'OPERACIONES'
group by osuser , MACHINE , PROGRAM , TERMINAL
order by count(*) desc , osuser , TERMINAL;

My Appl is automatic process and is running all day.

Over the Xp my appl is closing all inactive connections,
But in Win2k are not closing, so the number of session are growing up, in less than 30 minutes I get 18 session open and not used by the program.
So I need some help to configure the tsnames or slqnet
cause I know the problem is there.
Thxs
sahernandez

 

[sahernandez]

I guest that I fix the problem,
I change my ORA_OLDB by a MSORA connection.

I don't know why the ORA_OLDB connection give this problem, but I will try to read or search it.

Cheers
Sahernandez