Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: connection to the database is slow

Re: connection to the database is slow

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Fri, 3 Feb 2006 14:58:05 -0500
Message-ID: <367369f10602031158v11bdc1cfj3e257ee181458c89@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 03 2006 - 13:58:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US