Klaus,
How about an tcpdump ??. I would investigate in those
peak times because maybe an isolate traceroute or ping
doesn't say anything.
Regards.
- "Zinsmeister, Klaus {PTBF~Basel}"
<KLAUS.ZINSMEISTER_at_Roche.COM> wrote:
> 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).
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).
Received on Mon Nov 12 2001 - 10:01:58 CST