Slow connection time

From: Zinsmeister, Klaus {PTBF~Basel} <KLAUS.ZINSMEISTER_at_Roche.COM>
Date: Mon, 12 Nov 2001 03:40:30 -0800
Message-ID: <F001.003C21D0.20011112032517@fatcity.com>

Hi LIST,

I have a performace problem with the a Database. The time to connect takes upto 40 seconds and more.

Oracle 7.3.2.3
HP-UX 10.20

5 Databases on the Server, each has one listner running. One database has about 250 Session, the other only 10-15

I have TNSPING running (on the same server) to trace the problem. And during most of the time the response is good, but there are peeks with incredible response time ...

12-Nov-2001 08:53:48 ; OK (30 msec)
12-Nov-2001 08:54:48 ; OK (20 msec)
12-Nov-2001 08:55:49 ; OK (20 msec)
12-Nov-2001 08:56:49 ; OK (20 msec)
12-Nov-2001 08:57:49 ; OK (20 msec)
12-Nov-2001 08:58:50 ; OK (50 msec)
12-Nov-2001 08:59:50 ; OK (33290 msec)
12-Nov-2001 09:01:24 ; OK (70300 msec)
12-Nov-2001 09:03:34 ; OK (75030 msec)
12-Nov-2001 09:05:50 ; OK (50230 msec)
12-Nov-2001 09:07:40 ; OK (30260 msec)
12-Nov-2001 09:09:11 ; OK (20 msec)
12-Nov-2001 09:10:11 ; OK (60 msec)
12-Nov-2001 09:11:12 ; OK (30 msec)
12-Nov-2001 09:12:12 ; OK (20 msec)
12-Nov-2001 09:13:12 ; OK (20 msec)
12-Nov-2001 09:14:13 ; OK (20 msec)
12-Nov-2001 09:15:13 ; OK (20 msec)

In listner.ora I have (ENVS = 'EPC_DISABLED = TRUE') and the file process.dat in otrace/admin is small (300kb) and not growing.

Has somebody a hint what's going wrong here ?

Thanks,

Klaus

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Zinsmeister, Klaus {PTBF~Basel}
  INET: KLAUS.ZINSMEISTER_at_Roche.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 12 2001 - 05:40:30 CST