Query very slow on an Update version 12.1
Hello gurus,
I have a query very slow on an Update
Oracle database is V12.1.0.2
I have executed an tkprof to apply below :
I think that my problem is query = 195635288 how may i improve it ? see below
My query is :
SQL ID: 0g0smck8hwxq1 Plan Hash: 2234506511
UPDATE XX_PA021_REPRISE_COUTS SET EXPENDITURE_ITEM_ID = :B5
WHERE
1=1 AND OPERATING_UNIT = :B4 AND ORIG_TRANSACTION_REFERENCE = :B3 AND
SYSTEME_ORIGINE = :B2 AND REQUEST_ID = :B1 AND TRAV_PHASE_STATUS = '2' AND
TRAV_RECORD_STATUS = 'SU'
on report of tkprof
i see that i have 1 row for 1 execute and 1 access disk