Cardinality - reducing cost - High CPU usage
Dear Experts,
We are trying to reduce the cost of this program,it always consumes high CPU. Need your guidance to fix it. Please, kindly help us.
env: 2 node RAC
version 19.17
We have also attached the details here due to formatting issue.
Cursor:
======= -------------------------------- SQL_ID cx03bb88jvhtx, child number 0 ------------------------------------- UPDATE XXTTD.SVIMS_INV_QTY_STG SET STATUS_FLAG = 'E', STATUS_MSG = 'Duplicate Item Transaction_id' WHERE STAGING_ID IN (SELECT STAGING_ID FROM XXTTD.SVIMS_INV_QTY_STG WHERE STATUS_FLAG = 'N' AND SOURCE = :B2 AND TRANSACTION_ID IN(SELECT ATTRIBUTE15 FROM APPS.MTL_MATERIAL_TRANSACTIONS WHERE TRANSACTION_SOURCE_NAME =:B2 ) AND ITEM = :B1 ) Plan hash value: 3079752078 ------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ------------------------------------------------------------------------------------------------------------------------ | 0 | UPDATE STATEMENT |
0