Its a limitation in the OS. Only so many threads are allowed per process on
NT. I think the Advanced or data server NT or the 2000 version allows more.
so the answer is to go to UNIX :-) but you already knew that. Fortunately
all the Oracle stuff will work just fine on UNIX.
Jim
"SEJ" <sejprv_at_adsl.tele.dk> wrote in message
news:3db081bd$0$34814$edfadb0f_at_dspool01.news.tele.dk...
> Hi Daniel
>
> The OS is W2K.
> I had tried it with Enterprise and standard edition, it its the same if i
do
> it on a server with 2gb of RAM or my laptop with 256 mb of RAM, or a test
> server with 512 mb. I think the problem lies in the OS (do not comment
> please, -i know) I had tracked down some discussion from 1 year ago, and
the
> didn't solve the problem but change ther setup, read OS. so...
>
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3DB04394.23FD8C12_at_exesolutions.com...
> > SEJ wrote:
> >
> > > Hi
> > >
> > > I have looked through my documentation and can't find any limit on the
> > > number of dedicated connections. I know of course that I should run
MTS
> when
> > > I have about 3-400 OLTP connections.
> > >
> > > The limit I can reach is 1200 dedicated connections, and that are also
> what
> > > I can find in the groups and other places on the net, but can anyone
> tell me
> > > , -are there a limit ? and what is the limit ?
> > >
> > > regards
> > > Svend
> >
> > How much RAM do you have? And what king of license agreement do you have
> with
> > Oracle? ;-)
> >
> > I've run in the tens of thousands.
> >
> > Daniel Morgan
> >
>
>
Received on Fri Oct 18 2002 - 20:41:46 CDT
