Database Administration (MOSC)

MOSC Banner

Guidance - sql tuning

Hi Team,

We are on 19.28 version. We request you if there any recommendations to improve this sql.

--------------------------------------------
SQL_ID  1c1g86jhmbc5g, child number 0
-------------------------------------
SELECT TRANSACTION_ID, TOTAL_COST, ORGANIZATION_ID, INVENTORY_ITEM_ID
FROM XXMMS_INV_COST_ITEMS_TBL WHERE (TRANSACTION_ID IN (:1 , :2 , :3 ,
:4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 ,
:17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 ,
:29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 ,
:41 , :42 , :43 , :44 , :45 ,

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