Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow connect time
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 - 08:47:57 CDT