RefreshWorkspace slowed because of another SQL.

I apologize if this is the not the correct forum. I have noticed a slowness in a call to DBMS_WM.REFRESHWORKSPACE.

In debugging the problem I used the "oradebug hanganalyze 3" command which showed that it is waiting on the

following SQL:

SELECT SUM(DECODE(INSTR(DL.COLUMN_NAME, '"'), 0, BYTES, BYTES*20)/DECODE(NUM_ROWS, 0, 1, NVL(NUM_ROWS, 1)))

FROM DBA_TABLES DT, DBA_LOBS DL, DBA_SEGMENTS DS WHERE DT.OWNER = :B2 AND DT.TABLE_NAME = :B1 || '_LT' AND DL.OWNER = DT.OWNER

AND DL.TABLE_NAME = DT.TABLE_NAME AND DL.OWNER = DS.OWNER AND DL.SEGMENT_NAME = DS.S....