Update CLOB column is very slow in 11g R2 ( 11.2.0.4 )
We have 2 tables, please find description below -
SQL> desc ade_data.TEMP_ADV_VALUES
Name Null? Type
----------------------------------------- -------- ----------------------------
USER_ID CLOB
ADV_ID VARCHAR2(100)
TYPE CHAR(14)
SQL> desc ade_Data.gad_search_stage
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(200)
ADV_ID NUMBER
TYPE VARCHAR2(32)
TIME_STAMP TIMESTAMP(6)
FULLDATA CLOB
USER_ID CLOB
ACTIVE NUMBER(1)
the update statement we run is below -
UPDATE GAD_SEARCH_STAGE GSO SET USER_ID = (SELECT USER_ID FROM TEMP_ADV_VALUES WHERE ADV_ID = GSO.ADV_ID );