Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database login very slow
Hi there,
Just move $ORACLE_HOME/otrace/admin/process.dat and regid.dat files to a
Backup Location and see the difference. Or you can set EPC_DISABLED=TRUE in
U'r Session statup files.
The reason is becos Oracle Tracing is enabled by default in 7.3.3 version and it slows down the Connections.
-Thiru
Robert Krueger wrote:
> Hi,
>
> I have a problem with an Oracle 7.3.3 Server (HP-UX 10.20). Each login
> takes about 5 seconds whether it's sqlplus on the local machine or a
> remote connect from perl dbi or java jdbc.
>
> Could anyone give me a little hint where to look for the problem? I know
> it's not much diagnostic info as I am not really an Oracle admin.
>
> Thanks,
>
> Robert
>
> --
> (-) Robert Krüger
> (-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
> (-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
> (-) Tel: 06151 665401, Fax: 06151 665373
> (-) krueger_at_signal7.de, www.signal7.de
Received on Mon Aug 23 1999 - 15:18:44 CDT