Re: all frontend applications are hanging sometimes / backend is Oracle 8i

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Thu, 12 Oct 2000 21:36:58 -0500
Message-ID: <suct2j4alkae9d@corp.supernews.com>

I would need more details to give a better answer, but if your application appears to hang, you can query v$session_wait to see what the session is waiting on. If it is waiting for enqueue that means there is a lock on the object that the other session(s) are trying to write to. If the wait is for more data from the client then it is likely that the hanging issue is internal to the application rather than the database.

If you want to email me with more details I will try to help you.

--
Dave A


"Bernd Rosenau" <b_rosenau_at_web.de> wrote in message
news:v2ocusg9cacm78523pqr69h789chne7oht_at_4ax.com...


> Hello,

>

> our frontend software is programmed in VB 6.0.

> It connects to Oracle 8i using ADO

>

> Sometimes all frontend applications get into a hanging state.

> For me, it looks like a database problem (pending transactions etc.)

>

> How can i find out what is going on ?

> Which system tables shall i have a look at ?

>

> Are there any general rules to avoid such application locks ?

>

> Many thanks in advance for your help,

>

> Regards Bernd

>

Received on Thu Oct 12 2000 - 21:36:58 CDT