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

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

Post by Pascal Brica » Sun, 31 Dec 1899 09:00:00



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) ?

_____________________________________________________________
  ___
 |_)_)   Pascal BRICARD       mailto:

_____________________________________________________________

 
 
 

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

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) ?

_____________________________________________________________
  ___
 |_)_)   Pascal BRICARD       mailto:

_____________________________________________________________

2. Initiate Backup

3. Connecting to an Oracle 8i Database remotely....getting invalid connection string

4. Dimension question

5. Oracle JDBC Connection Problem (getting closer...)

6. RDO and GetChunk

7. RDO connection to ORACLE database through ODBC string literal too long

8. Help! This is driving me mad!

9. sql 2000 iis 5 ado database connection problem -- connections slow

10. Long time for closing connection

11. Very long connection times

12. The connection time from MDX to olap Server is too long

13. DSO : long connection time to a cube