1 Reply Latest reply: Feb 20, 2013 12:28 PM by Nikolay Savvinov RSS

    OLS on Exadata Performance Issues

      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.