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

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 - 20:08:01 CDT