connection takes several minutes!

From: Hohbeje B. <hohbeje_at_my-deja.com>
Date: Mon, 29 Nov 1999 21:37:35 GMT
Message-ID: <81urmu$5ku$1@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 Mon Nov 29 1999 - 15:37:35 CST