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

From: Bernd Rosenau <b_rosenau_at_web.de>
Date: Fri, 13 Oct 2000 03:04:27 +0200
Message-ID: <pincusgboshtupm7qeiprni93hu8b1vi5d@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 - 20:04:27 CDT