RE: Slow connctions

Good idea Jesse !

on TEST machine I got average 40 milliseconds

on PROD machine                       1010 milliseconds

What do you suggest to investigate ?
TIA
Franck Fribourg Switzerland

|--------+------------------------->

|        |          "Jesse, Rich"  |
|        |          <Rich.Jesse_at_qti|
|        |          world.com>     |
|        |                         |
|        |          00-08-28 20:44 |
|        |          Please respond |
|        |          to ORACLE-L    |
|        |                         |


|--------+------------------------->

  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Franck Vasseur/im/esa/ingerrand)                       |
  |       Subject:     RE: Slow connctions - 8.0.5.1 OpenVMS                   |
  >----------------------------------------------------------------------------|

Hi Franck,

Have you done a "TNSPING sid 50" on a client to see what the response time is?

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             QTI -- Sussex, WI USA


> -----Original Message-----
> From: Franck_Vasseur_at_ingerrand.com
> [mailto:Franck_Vasseur_at_ingerrand.com]
> Sent: Monday, August 28, 2000 12:42
> To: Multiple recipients of list ORACLE-L
> Subject: Slow connctions - 8.0.5.1 OpenVMS
>
>
>
>
> Hi there,
>
> Anybody experienced worst and worst elapsed time to login ?
>
> As a test I lauched at the same time 18 SQL*Plus. The
> connection time increase
> approx 1 second more for each login.
>
> i.e.
>
>   Charged CPU time:        0 00:00:00.44      Elapsed time:
>     0 00:00:05.63
>   Charged CPU time:        0 00:00:00.38      Elapsed time:
>     0 00:00:06.48
>   Charged CPU time:        0 00:00:00.45      Elapsed time:
>     0 00:00:07.55
>   Charged CPU time:        0 00:00:00.38      Elapsed time:
>     0 00:00:08.62


-----------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.

--
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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