Re: connection to the database is slow
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- Date: Fri, 3 Feb 2006 12:12:01 -0800
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@xxxxxxxxx> wrote:
>
> That's what I said.
>
> On 2/3/06, Jared Still <jkstill@xxxxxxxxx> 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@xxxxxxxxxxxxxxx > 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.
> > >
> > >
> > > --
> > > //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@xxxxxxxxxx
>
> http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
