Here's my situation:
I have a MS SQL Server 2008 R2 with a linked server to Oracle via OraOLEDB.Oracle provider.
I use a .net application to open a connection to my sql-server, execute a select that collects data through the linked-server-connection from the oracle database and after that I close to connection to the sql.
It does work so far,
but when I start my application, exit it proberly and start it again it seems that i get the same session as before (which is for some reasons very bad).
Is that the right/normal behavior?
Is there any way to avoid that?!
How does the OraOLEDB.Oracle provider handle the sessions if used in/as a linked server?