Inserts into parent table getting blocked
Oracle RAC DB
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Hi All,
We are facing a acute situation where normal vanilla insert into parent table are being blocked by insert into child table (in parallel).
Sample sqls
insert into tab_parent
values (:1, :2, :3,...... :n)
insert into tab_child
select /*+ parallel */ col_1, col_2,..... col_n
from tab_parent, tab_1, tab_2....
Is it normal behavior or am I missing something?
Thanks,
Sandeep