Before people jump on me about why this question on this forum .. The problem is only found in Exadata
I have a table on which I have OLS setting on a column. As the owner of the table, I update the values on this column to the new values as per the OLS label_tag value set in Exadata. The query is
update table1 t1
set t1.column1 =
(select t2.label_tag from table2 t2
where t2.column1 = t1.column1)
if the OLS is enabled while douing this operation, the update goes to never never land. Without OLS enabled, the update completes in a few minutes. There are about 300 million rows.