Re: sqlplus Connect Slow on

Hi,

• When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL> prompt

That means you had narrowed down the problem. It's not realted to your network.

Debug your sqlplus command by truss,trace,strace etc. with its child process. If problem occurs after creating Oracle process, debug Oracle process by adb, dbx etc. to see in which function Oracle is sleeping.

If truss etc. returns you are waiting for otrace files(*.dat as I remember), remove them.

regards...

Ray Stell wrote:

> what does uptime or top tell you when connections are
> slow?
>
> On Wed, May 29, 2002 at 02:23:30AM -0800, VIVEK_SHARMA wrote:
> >
> > NO MTS used
> >
> > Dedicated Oracle Database Connect processes exist
> >
> > Thanks
> >
> > -----Original Message-----
> > Sent: Tuesday, May 28, 2002 2:53 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello VIVEK_SHARMA,
> >
> > Do you use MTS?
> > Look at dispatchers load.
> >
> > Tuesday, May 28, 2002, 3:33:18 PM, you wrote:
> >
> >
> > V> OS. Tru64 Unix ver 5.1
> > V> Oracle 8.1.7.2
> > V> m/c GS320 Alpha Server
> >
> > V> After 900 User processes are Connected to a Database , sqlplus system/manager@<Connect String>
> > V> When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL> prompt
> >
> > V> Any parameters , pointers , Docs ?
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: VIVEK_SHARMA
> > INET: VIVEK_SHARMA_at_infosys.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).
>
> --
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
> 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).

--
Danisment Gazi Unal
http://www.ubTools.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: dunal_at_ubTools.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).