Monitoring connection pooling

  • Thread starter Thread starter Robert Scheer
  • Start date Start date
R

Robert Scheer

Hi.

I am using Visual Studio .NET 2003 and ODP.NET to access an Oracle
8.1.6 database. I want to monitor the connection pool but could not
find anything similar to the SQL Server Profiler to do that. Could not
find at Oracle's documentation anything specific to that issue. Where
can I find more information about monitoring connection pools when
using Oracle and ODP.NET? Are there any system tables that can be
queried?

Thanks,
Robert Scheer
 
Robert Scheer said:
Hi.

I am using Visual Studio .NET 2003 and ODP.NET to access an Oracle
8.1.6 database. I want to monitor the connection pool but could not
find anything similar to the SQL Server Profiler to do that. Could not
find at Oracle's documentation anything specific to that issue. Where
can I find more information about monitoring connection pools when
using Oracle and ODP.NET? Are there any system tables that can be
queried?
Click to expand...

The Oracle server has no idea wether an applicaion is pooling connections or
not. All connections are the same to Oracle. And there is tons of
information from Oracle about the current sessions. You might start with
something like

select *
from v$session
where type='USER'

David
 
Robert said:
Hi.

I am using Visual Studio .NET 2003 and ODP.NET to access an Oracle
8.1.6 database. I want to monitor the connection pool but could not
find anything similar to the SQL Server Profiler to do that. Could not
find at Oracle's documentation anything specific to that issue. Where
can I find more information about monitoring connection pools when
using Oracle and ODP.NET? Are there any system tables that can be
queried?

Thanks,
Robert Scheer
Click to expand...

From what you posted I have two comments:

1. You are working with an Oracle version that is unsupported and
an antique heading toward the label Jurrasic.

2. Define what it is that you are trying to monitor. The words you
have used "monitor the connection pool" has no specific meaning.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
(e-mail address removed)
(replace 'x' with a 'u' to reply)
 
Hi.

I am using Visual Studio .NET 2003 and ODP.NET to access an Oracle
8.1.6 database. I want to monitor the connection pool but could not
find anything similar to the SQL Server Profiler to do that. Could not
find at Oracle's documentation anything specific to that issue. Where
can I find more information about monitoring connection pools when
using Oracle and ODP.NET? Are there any system tables that can be
queried?

Thanks,
Robert Scheer
Click to expand...


Uh, which connection pool?
 
Back
Top