Why connection to the database takes > than 10 minutes

The following is a brief explanation of the database connection problem I am experiencing.
The databases are functioning normally!!!!!!!!!!!!!!. Yes there is no error message written to the log file.

When the problem occurred few days back we assumed it is of resource problem. Every GUI connection was taking 30% of the CPU and we have 2 CPU on server. Then I opened a tar with Oracle Support thinking it may be of corrupted system table problem. Oracle Support thinks it is resource problem . Any how I havn't closed the tar with Oracle yet.

 If a user gets the connection to the database he/she will not have any problem executing any statements on database. Looks like even when we have 20% of CPU is free the connection to the database takes approximately 10 minutes. Whe load on Servr is absolutely low then I have no problem connecting to the databases.Can it be any of the UNIX resource( any parameter settings not being set properly) being not available at that instant to the user trying to get connected? By the way I am running on HP-UX 10.20 with 7.3.4.2.0 oracle database. We have two instances one being run in Archive mode.

Any clues and suggestions are welcome.
Drona

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 13:55:17 CST