Connection Pooling on Oracle 11g w/ asp.net

Question

What is the best way to handle connection pooling with Oracle 11g and asp.net, I'm having issues where Oracle refuses to open up any new connections for the web app after a while.

This causes the request to time out and queue up.!

EDIT: Is there anything that I need to do in Oracle to fine tune this?

Are you sure you are actively destroying all your connections in code, for instance by employing a using statement? — Josh Pearce
– Josh Pearce, Commented Nov 24, 2009 at 15:34
Yes. oConn.Close(),. Is there someway to trace/view the amount of open connections? — Hector Minaya
– Hector Minaya, Commented Nov 24, 2009 at 15:54
Which database provider do you use? ODP.net, devart, dotconnect, Microsoft's provider for Oracle? — tuinstoel
– tuinstoel, Commented Nov 24, 2009 at 18:48

Tom Halladay · Accepted Answer · 2013-04-15 01:30:19Z

2

Since you didn't mention your Oracle config, its hard to tell you a first course of action, so you need to clarify how many sessions you have.

SELECT username, count(1) FROM v$session GROUP BY username;

Oracle's max is controlled by the "PROCESSES" instance parameter. The default may be something like 150. You may try bumping that to 300 or so for an OLTP web app, however, if you do have a leak, it will only delay the inevitable. But check the PROCESSES is at least as large as your "Max Pool Size" setting for your Oracle ADO connection string. Default for 11g ODP.NET is 100 I think.

edited Apr 15, 2013 at 1:30

Tom Halladay

5,7917 gold badges51 silver badges67 bronze badges

answered Jan 22, 2010 at 21:04

mrjoltcola

20.9k1 gold badge62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rob Allen · Accepted Answer · 2009-11-24 15:52:47Z

0

Closing the connections is all you need to do. The framework should handle all of the pooling.

answered Nov 24, 2009 at 15:52

Rob Allen

2,9112 gold badges31 silver badges51 bronze badges

Comments

Gary Myers · Accepted Answer · 2009-11-24 21:44:24Z

0

Querying the v$session would show all outstanding sessions. How many connections do you have and how quickly are you trying to create/disconnect them ? Shared servers is one mechanism to have multiple end clients share a limited number of connections.

answered Nov 24, 2009 at 21:44

Gary Myers

35.5k4 gold badges52 silver badges77 bronze badges

1 Comment

Hector Minaya Over a year ago

I see hundreds of sessions there. But where do I define/control it?

Collectives™ on Stack Overflow

Connection Pooling on Oracle 11g w/ asp.net

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related