Re: database login very slow

Hi Robert,

1 verify the setting of ORACLE_TRACE_ENABLED in init.ora. This is a known problem. By default it was true on 7.3.2 and 7.3.3 The database needs to be bounced to recognise the change 2 inefficient sqlnet.ora on the client (or server) For clients usually
automatic_ipc = off
names.directory_client = (tnsnames,onames)

Hth,

Sybrand Bakker, Oracle DBA

Robert Krueger <krueger_at_signal7.de> wrote in message news:37C10DA8.D899C05C_at_signal7.de...
> 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 - 12:12:45 CDT