Re: connection to the database is slow
- From: Jared Still <jkstill@xxxxxxxxx>
- To: ikar@xxxxxxxxxxxxxxx
- Date: Fri, 3 Feb 2006 11:46:16 -0800
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
Other related posts:
