Re: Why connection to the database takes > than 10 minutes

In article <712k36$8rp$1_at_nnrp1.dejanews.com>,   drona_at_my-dejanews.com wrote:
> 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
>

Hi,

 You could use GlancePlus/MeasureWare or something similar on HP to monitor and collect statisitics on Oracle server processes and the GUI connections when these connections are made. After looking at the statistics, you might spot the problem with the HP-UX system settings and then tune the HP-UX.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 09:52:03 CST