Re: solution has been found but till no explanation
From: Alexander Chupin <chupin_at_hotmail.ru>
Date: Wed, 14 Mar 2001 13:05:39 -0000
Message-ID: <98nptn$efj$1_at_soap.pipex.net>
Date: Wed, 14 Mar 2001 13:05:39 -0000
Message-ID: <98nptn$efj$1_at_soap.pipex.net>
> Because without such an index, the merest DML on the parent table will
lock
> the entire child table from ALL DML for the duration of the transaction.
[Quoted] Firstly, it seems locking entire table occurs not for child but for master table. You can easy look it if will monitor dba_lock view.
[Quoted] Secondly, my main question is WHY Oracle behaviour is DIFFERENT when trigger for master table is DISABLED or ENABLED? (for more details look my previous posting)
Please, before your next post make easy
experiment which I exactly described in my
previous letters. If you till see nothing strange
you can ignore this message.
Thanx for your attention.
WBR, Alexander Chupin Received on Wed Mar 14 2001 - 14:05:39 CET