Re: Multi-Threaded Server ?

Hi,

I use Windows NT 4 Server on a AMD Athlon 800 Mhz with 512 Mo of Ram and with only one client connected to Application Server which is connected to Oracle database I experiencing swap problem.

When I use SQL Server 7 I experiencing no problem of swap.

Maybe Oracle 8i database needs more Ram than SQL Server 7 one.

Do you have any idea of the amount of RAM and swap to allocate to Oracle 8i ?

Thanks,

Jim Kennedy wrote:
>
 

> 100 connections, that is not very many. You don't need MTS for only 10
 0
> connections. What problem are you experiencing?
> Jim
>
 

> "Julien Reynier" <julienr_at_satis.com> wrote in message
> news:3AF154BF.1D104D5F_at_satis.com...
> > So inspite of Oracle help, need to activate Multi-thread Server is
> > related to the number of connections and not to the number of clients
 .
> > If I use only one client but with a lot of connections I have to use
> > Multi-thread Server.
> >
> > Am I right ?
> >
> > Steve Long wrote:
> > >
> > > must use MTS? no.
> > > should use MTS? yes.
> > > oracle manages its own connection pool internally. there are no AP
 Is to
> > > "hook them up".
> > >
> > > "Julien Reynier" <julienr_at_satis.com> wrote in message
> > > news:3AF12AB0.8B23ED78_at_satis.com...
> > > > Hi,
> > > >
> > > > We developpe a CRM application (so we have OLTP problems) that u
 ses
> > > > Oracle 8i (8.1.6 or 8.17 depending of our clients) with Weblogic
 4.5.1
> > > > EJB Application Server.
> > > >
> > > > In our CRM application Light Clients (Internet Browsers) are conn
 ected
> > > > to a weblogic application server which is connected to Oracle8i
 database
> > > > by using a weblogic connection pool. So there is only one real
 Database
> > > > client (the Weblogic 4.5.1 server), but this client uses a lot of
 

> > > > connections (up to 100 connections are stored in the pool). So I
 would
> > > > like to know if I must use Multi-Threaded Server or not.
> > > >
> > > > Moreover if we have to use Multi-Threaded Server how can we tune
 the
> > > > Weblogic 4.5.1 connection pool to dialog with Oracle 8i connectio
 n
 pool.
> > > >
> > > > Thanks,
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Julien Reynier
> >
> > --
> > Julien Reynier

-- 

Julien Reynier de Montlaux

Recherche & D veloppement
Satis
01.55.35.03.13
06.83.29.40.47