URGENT!!!!!!!!!!!!!!!!! Low performance in lock situations between sessions

From: Pedro Talavera <ptalavera_at_copreci.es>
Date: Mon, 15 Nov 1999 14:36:48 +0100
Message-ID: <38300C70.D20512C6_at_copreci.es>

Hi everybody! [Quoted]
   We have experiencing problems with locks in Oracle.
Some processes have problems showing very different response depending of the existence of concurrent sessions, but not having locks of common data, it seems that if one session locks data in a master table, the access to relationed tables that depend of this master table becomes slower as if the master table has not locks.

    I have seen this because if the session that locks the master table ends, then the process goes fine, increasing the speed a lot.

    The Oracle RDBMS --> 7.3.4.4
    AIX 4.3.2

    Could some body give me more data about this?
    Is it a bug?
 

                                                                                    &nbs p;                                                           Thanks in advance.
                                                                                    &nb sp;                                                           Pedro Talavera.
                                                                                    &nb sp;                                                           ptalavera_at_copreci.es
  Received on Mon Nov 15 1999 - 14:36:48 CET