SQL Language (MOSC)

MOSC Banner

Why does the SQLID of a query change on each execution?

Product: Oracle DB Enterprise 11.2.0.4

SO: Linux red Hat 6.9

Question: There are one sql queries where the date parameter is textual and is changed on each execution, it is executed once daily, but from 01-26-2022 onwards the sqlid of the statement changes with each execution, which has increased the time required for its complete execution, you want to know why it did not happen before and now if it changes in each execution?

Query:

SELECT statement at runtime: WITH

Distline

AS

(select Bi.Id,

 Ramo.TypeCode Ramo,

 RieExt.TypeCode Riesgo,

 rrl.Percentage Porcentaje,

 rrl.Amount TotalAmount,

 rrl.Amount Amount,

 bi.jobnumberext

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