SQL Performance (MOSC)

MOSC Banner

SQL with different behavior

Hi,


how can I analyze the behavior of this single query executed several times, which on some days has a significant elapsed time with almost 100% CPU time and a large number of buffer gets ?


RDBMS      : 19.0.0.0.0
CPU_Count  : 16
Num Cores  : 16
Block Size : 8192
OFE        : 19.1.0

SELECT  ...

FROM  zcptesl0

WHERE

  cptesleta = :etab

  AND cpteslpla = :plan

  AND cpteslref = rpad(:refer, 26, ' ')

  AND cpteslobl = rpad(:coobl, 10, ' ')

  AND key_mbr = 'ZCPTESL0'

  AND cpteslage = :agence

  AND cptesldev = :devise

ORDER BY

  cptesleta, cpteslpla, cpteslobl, cptesldev, cpteslage, cpteslcom

Best regards

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