RE: Slow connection time

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 12 Nov 2001 08:37:56 -0800
Message-ID: <F001.003C2664.20011112080024@fatcity.com>

Did you turn off the oracle trace on the server? Sometimes, but just sometimes,
the only way is to set EPC_DISABLED environment variable to TRUE in the oracle
environment before you start up the database.

-----Original Message-----
[mailto:KLAUS.ZINSMEISTER_at_Roche.COM]
Sent: Monday, November 12, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L

Hi Christian,

ping and traceroute are OK (1 hops) and it is not a DNS problem.

Klaus

-----Original Message-----
Sent: Montag, 12. November 2001 13:30
To: Multiple recipients of list ORACLE-L

Download a free version of traceroute for HP-UX ( I think it doesn't come with the software ) and issue a traceroute to the site. Either the name or the ip. Or both. Have you issued a ping ?.

• "Zinsmeister, Klaus {PTBF~Basel}" <KLAUS.ZINSMEISTER_at_Roche.COM> wrote:
  > 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).
  

  ---

ENG. Christian Trassens
Senior DBA
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
Phone : +34-699240979
+34-649824704

---

Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.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).
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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 - 10:37:56 CST