Connections versus Sessions

From: Tim Smith <timasmith_at_hotmail.com>
Date: 25 Mar 2004 07:39:10 -0800
Message-ID: <a7234bb1.0403250739.1d0270a6@posting.google.com>

If I monitor v$session I can see a lot of sessions being created and destroyed. The application is .Net 1.0 using OLEDB and should have a connection pool that enables reuse of existing connections.

So there is the confusion - reuses existing connections not sessions right, there is a difference apart from the spelling I assume. Sometimes I see several SQL being executed, sometimes not. I guess it has something to do with ASP.NET object management

I assumed that you made 1 or more connections which was an inherently expensive operation (takes a full second for my Java program to connect). But should I be worried by the **sessions** not being reused. Received on Thu Mar 25 2004 - 09:39:10 CST