Re: connection to the database is slow

Well, yes, except you left out the location and name of trace files, and the EPC_DISABLED environment variable.

:)

Jared

On 2/3/06, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
>
> That's what I said.
>
> On 2/3/06, Jared Still <jkstill_at_gmail.com> wrote:
> >
> > Check your $ORACLE_HOME/otrace/admin directory.
> >
> > Do you have some rather large *.dat files there?
> >
> > If so, Oracle Trace is turned on.
> >
> > Google for EPC_DISABLED for more info.
> >
> > This was definitely a problem on 7.3 as Oracle Trace was on by
> > default.
> >
> > I can't recall if was still a problem with 8i, but it's worth a look.
> >
> > HTH
> >
> > Jared
> >
> > On 2/3/06, Inessa Weiner <ikar_at_med.cornell.edu > wrote:
> > >
> > > It takes a long time to get connected to our Oracle 8i database.
> > > Once connection got established the performance is OK. However it may
> > > take
> > > few minutes to get connected.
> > > We are in dedicated mode. Any points how to investigate the problem?
> > >
> > > Please help.
> > > Thanks,
> > > Inessa.
> > >
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
>
>
> --
> Regards,
> Ranko Mosic
> Contract Senior Oracle DBA
> Oracle 10g, 9i Certified Database Professional
> Phone: 416-450-2785
> email: mosicr_at_rogers.com
>
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l