SQL Performance (MOSC)

MOSC Banner

A sql performance tuning issue

edited Jul 7, 2015 10:09AM in SQL Performance (MOSC) 7 commentsAnswered

following is the sql monitor report:

SQL Monitoring Report

SQL Text
------------------------------
UPDATE /*+parallel(A 16)*/ TCSM_PSI_C_IMEI_INTERFACE_T A SET (A.ITEM_CODE, A.PACKING_LIST_NO, A.FLAG, A.PRODUCT_BARCODE) = (SELECT /*+first_rows(1)*/ T.ITEM_CODE, T.PACKING_LIST_NO, 8, T.PRODUCT_BARCODE FROM TCSM_PSI_IMEI_T T WHERE (T.IMEI1 = A.IMEI OR T.IMEI2 = A.IMEI) AND ROWNUM = 1) WHERE EXISTS (SELECT 1 FROM TCSM_PSI_IMEI_T M WHERE (M.IMEI1 = A.IMEI OR M.IMEI2 = A.IMEI)) AND A.FLAG <= 5

Global Information
------------------------------
Status                                 :  EXECUTING                                       
Instance ID                            :  1                                               
Session                                :  TCSM (224:34457)                                
SQL ID                                 :  b7j2scz7j4qnr                                   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center