Long running task

I have a proc that is running since more than half an hour.

How can i expedite the procedure.


The proc is stuck at this update:

UPDATE IVRSN A
   SET BASE_PRICE =
          BASE_PRICE
          * CASE BASE_PRICE_CCY
               WHEN 'USD'
               THEN
                  1
               ELSE
                  (SELECT PX_MID_PRC
                     FROM UCUR_CCY_EXCH_RATE_VU
                    WHERE     AS_OF_DT = A.RELEASE_DATE
                          AND CCY_FROM_CD = A.BASE_PRICE_CCY
                          AND CCY_TO_CD = 'USD')
            END
          * (SELECT NVL (MULT_FACTOR_VAL, 1)
               FROM MD_CCY_MULT_FACTOR
              WHERE CCY_CD = A.BASE_PRICE_CCY),
       BASE_PRICE_CCY = 'USD',
       CLOSE_PRICE =
          CLOSE_PRICE
          * (SELECT NVL (MULT_FACTOR_VAL, 1)
               FROM CCY_MULT_FACTOR
              WHERE CCY_CD = A.CONSTITUENT_CURRENCY_CODE)
 WHERE A.AS_OF_DT = :B1


There is a Row-X (SX) mode DML lock on table IVRSN and table partition IVRSN

Explain plan shows full table scan of IVRSN with cost of 6,00,000