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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
