This discussion is archived
1 Reply Latest reply: Feb 20, 2013 10:28 AM by Nikolay Savvinov RSS

OLS on Exadata Performance Issues

amin_adatia Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points