Hello all,
So far my understanding was Select Statement will not cause blocking other sessions, i am experiencing the block session due to Select statement in Oracle 12.1 version .
Here is my example ,
I have a procedure that has insert into target table statement like below
Insert Into Target_tab select columns from source_tab1, source_tab2 , source_tab3 Join Condition
at the same time , in different sessions DML operations are happening on the source_tab1, source_tab2 , source_tab3
In this scenario The DML operations are slowed down and many session waiting for the select statement to complete for inserting data into Target_Tab Table.
The first query is just a Select statement but blocking other sessions, Please give your view why Block is happening for select statements, Thanks in advance .