Monitoring connection pooling

[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

 

[David Browne]

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?

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

 

[Daniel Morgan]

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

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)

 

[Greg Forestieri]

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

Uh, which connection pool?