Re: Connections to Oracle get slower and slower...

You don't have the ipc protocol defined in listener.ora While it is very unlikely this is the problem, it probably does force 'local' connections (on the database server to the database) to use tcp/ip instead of ipc.
Add the line
address= (protocol = ipc)(key=extproc0) to the listener_address block the total block will look like
listener_address =
(
  (address=(protocol=tcp)(host=) (port=)   address= (protocol = ipc)(key=extproc0) )

I once read a general guideline: 50+ connections implies use MTS.

Hth,

Sybrand Bakker, Oracle DBA

Jean-Christophe Boggio <cat_at_elma.fr> schreef in berichtnieuws 8dnm99$o41$1_at_reader1.imaginet.fr...
> Hello,
>
> We run Oracle 8.0.5 on a NT Enterprise server for a web site. Everything
> except Oracle runs on Linux with *no* problem. Before going to production,
> Oracle behave perfectly. All our db accesses were instantaneous, all the
> time, perfect.
>
> Now that we have quite a lot of connections to the site we have a strange
> problem : connection to Oracle is slow. Once connected the queries are
 very
> fast but connect time is going from 2secs to 30 or more seconds.
>
> I have seen many time 20seconds to connect from the *LOCAL* SQLWorksheet
 or
> SQL*PLUS, on the same machine as the one Oracle is running on.
>
> I've read all the Osborne books about tuning, troubleshooting, searched
 the
> web for an identical problem but nope.
>
> I posted a message a few days ago about Oracle hanging with many
> connections, this is the same problem : connect time.
>
> Someone replied with MTS and Connection pooling. I don't know yet if that
> can help (my night will be used for this).
>
> I hesitate between trying to fix this problem (which seems VERY simple) or
> reinstalling on a Linux box.
>
> Memory is underemployed (300megs unused). The databases are very small and
> it doesn't look like a SQL problem.
>
> Thanks for your help.
>
>
>
>
Received on Fri Apr 21 2000 - 00:00:00 CDT