SQL Performance (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center