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

A copy of this was sent to Pedro Talavera <ptalavera_at_copreci.es> (if that email address didn't require changing) On Mon, 15 Nov 1999 14:36:48 +0100, you wrote:

>Hi everybody!
> 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?
>

sounds like unindexed foreign keys. see http://osi.oracle.com/~tkyte/unindex/index.html for more info.

>
>
>Thanks in advance.
>
>Pedro Talavera.
>
>ptalavera_at_copreci.es

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation