Re: TNS-12500

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Sat, 12 Jul 2003 15:38:46 +0200
Message-ID: <3f100f49$0$49110$e4fe514c@news.xs4all.nl>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> schreef in berichtnieuws fp00hvg43gj2shab6u9pf313nkkflt1n1t_at_4ax.com...
| On Sat, 12 Jul 2003 12:10:10 +0200, "Anton Buijs"
| <remove_aammbuijs_at_xs4all.nl> wrote:
|
| >Just an idea, maybe it does not make any sense. Could it be you hit a
limit
| >in the number of TCP/IP connections Windows 2000 can handle. Or some
other
| >limit in the TCP/IP configuration.
|
|
| He must be hitting the maximum number of threads per process.
|
|
| Sybrand Bakker, Senior Oracle DBA
|
| To reply remove -verwijderdit from my e-mail address

He mentions a few hundred of connections.Don't know what the max threads per process on Windows 2000 is or if it is configurable. Anyway, with > 200 connections this database can be a good candidate for a Multi Threaded Server setup.
If max threads/process is the problem MTS is a solution (maybe the only one). Received on Sat Jul 12 2003 - 08:38:46 CDT