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