Re: Slow connect time

From: Giorgos Tsiamitas <gtsiam_at_gmx.net>
Date: Wed, 23 May 2001 18:00:39 GMT
Message-ID: <bVSO6.235$ex4.7687@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

> > >

> > >

> > >

> >

> >

>

>

Received on Wed May 23 2001 - 13:00:39 CDT