Re: Oracle 7.3.2 Connection problem : very long time to get a connection

Pascal Bricard a écrit :

> I have an Oracle 7.3.2 installed on a Bull Server AIX 4.1.5 Escala
> computer with 256 Mo memory.
>
> At any time there are about between 5 and 10 oracle processes running,
> each one corresponding to one database active connection.
>
> I login the server, then i run SQL Plus tool and connect to the DataBase:
> i have to wait from 1 minute to more than 3 minutes to get the "SQL>"
> prompt.
>
> What method could i use to find out this problem (is it an Oracle problem
> or an AIX one) ?
>

Try to see if you don't have a 'login.sql' file on your directory that's doing some 'strange' things.

After that, try to run 'sqlplus /nolog' and type 'connect count/passwd', if you wait at the first
command, there's a problem with AIX (not enough memory, swap space, ...); if you wait after
the second one, this is an Oracle problem (.ora parameters, ...).

Hope this helps.

Pierre Received on Mon Jan 17 2000 - 06:09:29 CST