Re: Slow connect time

Giorgos,

Thanks again for your help. These queries turned up no rows/false/no rows, so I guess it is something else.

I suspect it is logging of some kind since it just started doing this and I haven't changed anything that I know of. But I don't see any logs that have grown excessively.

--
Mark

"Giorgos Tsiamitas" <gtsiam_at_gmx.net> wrote in message
news:bVSO6.235$ex4.7687_at_nreader1.kpnqwest.net...


> Here are some things to try 1-by-1. Please note that apart from auditing,

> trace and triggers, other factors may cause long connection waits and

 there


> is no standard identification and remedy.

>

> Auditing

> ------------

> select * from dba_priv_audit_opts where privilege='CREATE SESSION';

>

> if you get no result then session auditing is not enabled. Otherwise use

> NOAUDIT CREATE SESSION statement or set ini parm AUDIT_TRAIL=none

>

> For more info see Administrator's Guide, Auditing Database Use

>

>

> Trace

> -------

> select value from v$parameter where name ='sql_trace';

> if you get FALSE then ok. Otherwise set SQL_TRACE=false in init.ora and

> restart the database.

>

> For more info see Oracle 8i Reference, Initialization Parameters

>

>

> Logon Triggers

> ---------------------

> select owner, trigger_name from dba_triggers where

 triggering_event='LOGON'


> and status='ENABLED';

> If no rows returned then there is no logon trigger; otherwise use ALTER

> TRIGGER ... DISABLE statement.

>

> More info at Oracle8i SQL Reference.

>

> --

> Giorgos

> "Mark Fraser" <mark101doesntlikespam_at_telocity.com> wrote in message

> news:VaPO6.4218$ce.5103570_at_newsrump.sjc.telocity.net...

> > Giorgos,

> >

> > Thanks for the reply.

> >

> > Could you please tell me specifically where/how

> > I change these settings, or at least point me to which

> > documentation explains this?

> >

> > Thanks,

> >

> > Mark

> >

> > "Giorgos Tsiamitas" <gtsiam_at_gmx.net> wrote in message

> > news:1PLO6.73$ex4.3682_at_nreader1.kpnqwest.net...

> > > Try:

> > >

> > > a. turning auditing off. Check DBA_PRIV_AUDIT_OPTS and

 DBA_STMT_AUDIT_OPTS


> > > to see if auditing is set for "create session".

> > >

> > > b. turning instance-wide session tracing off (ini parm

 SQL_TRACE=false)


> > >

> > > c. disabling logon triggers, if any

> > >

> > > --

> > > Giorgos

> > >

> > > "Mark Fraser" <mark101doesntlikespam_at_telocity.com> wrote in message

> > > news:1%JO6.4074$ce.4869134_at_newsrump.sjc.telocity.net...

> > > > Hello,

> > > >

> > > > I am running Oracle 8i Enterprise Edition and have suddently

> > > > started experiencing slow connect times.  The slowness occurs

> > > > in both SQLPLUS and when connecting via JDBC.  It occurs

> > > > when connecting from the same machine on which the server

> > > > resides.

> > > >

> > > > TNSping returns in 20 ms.

> > > >

> > > > When I run SQLPLUS, I immediately get a login prompt, but it takes

> > > > about fifteen seconds to connect after entering login info.  The

> > > > same slowness occurs when I login via SQLPLUS username/password.

> > > > I have tried with tracing both on and off.  And I tried renaming

> > > > the .dat files in .\otrace\admin which are about 1M.

> > > >

> > > > System:

> > > >

> > > > Win 2K

> > > > 256 MB RAM

> > > > Duron 750

> > > >

> > > > I don't see any other logs that have grown unreasonably.

> > > >

> > > > Any suggestions?

> > > >

> > > > Thanks,

> > > >

> > > > Mark

> > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>