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).
Received on Mon Nov 12 2001 - 06:41:45 CST
