Very Computer

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:

_____________________________________________________________

Pascal Bricard a crit :

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

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

       You may have Oracle Trace enabled by default. Symptoms such as
you describe were often seen on 7.3.2 bases as a result of Oracle Trace
not being turned off.
       Quick check & fix: "cd" to $ORACLE_HOME/otrace/admin . If there
are some extremely large files with ".dat" extension (particularly
"regid.dat") this will confirm the above suggestion. Deleting all the
".dat" files should make your symptoms go away.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

Quote:

> 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

A man from Oracle France Support sent me by mail the right answer. It is
a problem with connection tracing.

You can see the problem report at :

http://www.veryComputer.com/

Pascal

(Samba Technologies : ex Unilog Meylan)

PS: heureu*t qu'on a les newsgroup internationaux pour rester en
contact alors que l'on est physiquement dans des locaux distants d'au
moins 300 m...

_____________________________________________________________
  ___
 |_)_)   Pascal BRICARD       mailto:

_____________________________________________________________