Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connection takes several minutes!
I wouldn't think that the CPU would be the problem, but I would check the
disk activity for bottlenecks. Also, check the $ORAHOME/dbs/otrace/log (not
sure if this is exact) for some .dat files. These files have a tendency to
get very large (we had some >40meg) , and during heavy loads seem to slow
the connection process. I "moved" the files to a different name (mv *.dat
*.bk). This took care of the problem that was causing users to wait for
minutes while connecting to the DB and now is almost instantanious. Good
Luck.
JH
Hohbeje B. <hohbeje_at_my-deja.com> wrote in message
news:81urmu$5ku$1_at_nnrp1.deja.com...
>
>
> When a session is performing a job and taking about 100% of 1 CPU, any
> other session connection takes several minutes to start, even when the
> second CPU is free.
>
> The same is happening when I try to start a new SQL query in existing
> connection.
>
> Is there something to do with the multi-threaded server that is not set
> correctly?
> mts_max_dispatchers 5
> mts_max_servers 20
> mts_servers 1
> mts_multiple_listeners FALSE
>
> I run Oracle8i 8.1.5 on Solaris 2.6
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 30 1999 - 19:48:39 CST