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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
