It's version 188.8.131.52.0 in which I see those in gv¶meter. But yes here
as we see multiple queries chaging plan so I was trying to find out what
all such parameters changed here from 11.2 to 19.9 upgrade. But it seems
dba_hist_parameter won't help as those parameters were not there in 11.2
version in gv¶meter view. Is there any other way?
On Wed, 20 Oct 2021, 6:26 am Mladen Gogala, <gogala.mladen@xxxxxxxxx> wrote:
On 10/19/21 17:01, Pap wrote:
Thank you Andy. I queried gv$parameter and saw below.
You saw underscore parameters in gv$parameter? That's something new. I
usually had to query X$KSPPI and X$KSPPCV. Which version of Oracle
shows the underscore parameters in gv$parameter?
Tel: (347) 321-1217