Database Tuning (MOSC)

MOSC Banner

Query very slow on an Update version 12.1

edited Feb 12, 2020 4:40AM in Database Tuning (MOSC) 15 commentsAnswered

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

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